On Wed, Oct 15, 2008 at 1:23 PM, Richard Broersma <[EMAIL PROTECTED]> wrote: > On Wed, Oct 15, 2008 at 12:08 PM, ries van Twisk <[EMAIL PROTECTED]> wrote: >> May be this function can help : >> >> http://www.postgresql.org/docs/8.3/static/functions-srf.html > > Using generate series won't number the rows that way that you would > want. You basically will end up with a cross join between the > generated series and the requested set. There are three ways that I > know of to get a row number:
Can't you put the query into a subselect with an offset 0 and join to that to get the generate_series to work correctly? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
