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 по дате отправления