Re: [MonetDB-users] offset support?

27 Nov 2007


      On Nov 26, 2007 10:51 AM, m h  wrote:
...
On Nov 26, 2007 10:47 AM, Fabian Groffen  wrote:
...
On 26-11-2007 10:40:53 -0700, m h wrote:
...
Is there support for OFFSET in queries?
It used to be there.  Have you tried select bla offset 2 limit 3 instead
already?
You mean this?
sql>SELECT query_users.user_id, query_users.user_name
more>FROM query_users ORDER BY query_users.user_id
more>OFFSET 2 LIMIT 3 ;
!syntax error, unexpected LIMIT, expecting INTERSECT or EXCEPT or
UNION in: "select query_users.user_id, query_users.user_name
!from query_users order by query_users.user_id
!offset 2 limit"
Timer     892.177 msec 0 rows
It appears that the "ORDER BY" is throwing things off.  Bug?