support for NEXT VALUE FOR expression

От
Peter Eisentraut
Тема
support for NEXT VALUE FOR expression
Дата
Msg-id
222bdd8b-7702-64e9-82f3-14ce2ca43875@2ndquadrant.com
Список
Дерево обсуждения
support for NEXT VALUE FOR expression Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: support for NEXT VALUE FOR expression Tom Lane <tgl@sss.pgh.pa.us>
Re: support for NEXT VALUE FOR expression Thomas Munro <thomas.munro@enterprisedb.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>
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
Дата:
Поиск
Список
Период
Сортировка
Искать
FAQ