Re: How to select and result row number??

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to select and result row number??
Дата
Msg-id 24103.1032275124@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to select and result row number??  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список pgsql-sql
"Ross J. Reedstrom" <reedstrm@rice.edu> writes:
> Hmm, with the new dependency code, is the auto-sequence from a SERIAL
> in a temp table also a temp sequence? It get's put in the temp schema,
> right? Seems we have a workaround for those wanting numbered result
> sets.

That's the hard way; just do CREATE TEMP SEQUENCE ... works in prior
releases too ...
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: How to select and result row number??
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Returning a reference to a cursor from a function