On Wed, May 07, 2008 at 12:15:16AM +0100, Henrik Vendelbo wrote:

The section on sorting and limit

3.1.7.2 Select lists, distinct, sorting, limit

Is very brief and doesn't seem to describe limit/sort, does this mean that LIMIT/OFFSET is supported or that ROW_NUMBER should be used? Both limit and offset are supported, and we are working on row_number Example

SELECT query_users.user_id, query_users.user_name FROM query_users LIMIT 3 OFFSET 2; Niels

Henrik

------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao... _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl