support for NEXT VALUE FOR expression

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема support for NEXT VALUE FOR expression
Дата
Msg-id 222bdd8b-7702-64e9-82f3-14ce2ca43875@2ndquadrant.com
обсуждение исходный текст
Ответы Re: support for NEXT VALUE FOR expression  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: support for NEXT VALUE FOR expression  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Here is a patch for implementing the NEXT VALUE FOR expression.  This is
the SQL-standard conforming version of our nextval() function, and it's
also used by Oracle, MS SQL, DB2.  Example:

SELECT NEXT VALUE FOR foo_seq;

The second patch changes the serial column to use this new expression
for its generated default values.  This doesn't make an external
difference except perhaps that the generated expression looks less weird
to the user.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: LWLocks in DSM memory
Следующее
От: Tom Lane
Дата:
Сообщение: Re: support for NEXT VALUE FOR expression