[MonetDB-users] offset support?

26 Nov 2007

      Is there support for OFFSET in queries?

The syntax doesn't throw an error, but the expected behavior isn't correct...

sql>select * from query_users;
+---------+----------+
 |user_id |user_name |
+=========+==========+
 |      1 |john      |
 |      2 |jack      |
 |      3 |ed        |
 |      4 |wendy     |
 |      5 |laura     |
 |      6 |ralph     |
 |      7 |fido      |
+---------+----------+
Timer       1.820 msec 7 rows
sql>
Timer       0.294 msec 0 rows
sql>SELECT query_users.user_id, query_users.user_name
more>FROM query_users ORDER BY query_users.user_id
more> LIMIT 3 OFFSET 2;
+---------+----------+
 |user_id |user_name |
+=========+==========+
 |      1 |john      |
 |      2 |jack      |
 |      3 |ed        |
+---------+----------+

-matt

m h

Fabian Groffen

m h

m h

Niels Nes

m h

m h

Niels Nes

m h

Niels Nes

m h

tags

participants (3)