On Wed, Oct 15, 2008 at 1:23 PM, Richard Broersma <richard.broersma@xxxxxxxxx> wrote: > On Wed, Oct 15, 2008 at 12:08 PM, ries van Twisk <pg@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
