Re: "RETURNING PRIMARY KEY" syntax extension - Mailing list pgsql-hackers

From Gavin Flower
Subject Re: "RETURNING PRIMARY KEY" syntax extension
Date
Msg-id 5395EA2D.6050203@archidevsys.co.nz
Whole thread Raw
In response to Re: "RETURNING PRIMARY KEY" syntax extension  (Vik Fearing <vik.fearing@dalibo.com>)
List pgsql-hackers
On 09/06/14 23:42, Vik Fearing wrote:
> On 06/09/2014 09:06 AM, Gavin Flower wrote:
>>  From memory all unique keys can be considered 'candidate primary keys',
>> but only one can be designated 'the PRIMARY KEY'.
> Almost.  Candidate keys are also NOT NULL.
Yeah, obviously!
(Except, I did actually forget that - me bad.)



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inaccuracy in VACUUM's tuple count estimates
Next
From: Andres Freund
Date:
Subject: Re: "RETURNING PRIMARY KEY" syntax extension