Re: LIMIT clause in sub-query?

Hi Dennis, I asked about this recently - please see this thread https://www.monetdb.org/pipermail/users-list/2013-October/006855.html In particular answers to my question here: https://www.monetdb.org/pipermail/users-list/2013-October/006857.html Thanks, Pete. On 22 November 2013 11:13, Dennis Pallett wrote:

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