Hello all,

I'm trying to use a LIMIT clause in a sub-query but MonetDB doesn't seem to be able to handle it. A very simple example query would be:

SELECT COUNT(*) AS gt_result FROM (
    SELECT * FROM nyc_buildings LIMIT 10
) AS temp;

The result of this query should be 10 and works fine in PostgreSQL. However MonetDB gives the following error:

syntax error, unexpected LIMIT, expecting INTERSECT or EXCEPT or UNION or ')' in: "<original query>"

Is this a bug in MonetDB? Any way to work around it?

Best regards,
Dennis Pallett
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list