On Wed, Jan 05, 2011 at 08:16:26PM +0100, Fabian Groffen wrote:
On 05-01-2011 08:01:00 -0800, Brett Spurrier wrote:
Thanks Fabian! I'll give that a try. I knew it had to be something simple I was doing wrong.
If it doesn't work, try it the other way around (LIMIT 1 OFFSET 1), I always forget which is the right way, and/or if I back then implemented both orders.
According to our SQL syntax description, it is indeed "LIMIT 1 OFFSET 1"; cf., http://monetdb.cwi.nl/SQL/Documentation/Queries.html Stefan
------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |