Re: [HACKERS] support for NEXT VALUE FOR expression

2016-08-16 Thread Tom Lane
Peter Eisentraut writes: > 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. BTW, several of the earlier threads complained of

Re: [HACKERS] support for NEXT VALUE FOR expression

2016-08-16 Thread Tom Lane
Thomas Munro writes: > On Wed, Aug 17, 2016 at 3:52 PM, Tom Lane wrote: >> We discussed this before and concluded that NEXT VALUE FOR is in fact >> *not* an exact semantic equivalent of nextval(): >>

Re: [HACKERS] support for NEXT VALUE FOR expression

2016-08-16 Thread Thomas Munro
On Wed, Aug 17, 2016 at 3:52 PM, Tom Lane wrote: > Peter Eisentraut writes: >> 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

Re: [HACKERS] support for NEXT VALUE FOR expression

2016-08-16 Thread Tom Lane
Peter Eisentraut writes: > 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: We discussed this before and concluded