Postgres Pro
Downloads
Home   >   mailing lists

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

From Vik Fearing
Subject Re: "RETURNING PRIMARY KEY" syntax extension
Date
Msg-id 53959D9E.9040507@dalibo.com
Whole thread Raw
In response to Re: "RETURNING PRIMARY KEY" syntax extension  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Responses Re: "RETURNING PRIMARY KEY" syntax extension  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: "RETURNING PRIMARY KEY" syntax extension  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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.
-- 
Vik

pgsql-hackers by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Allowing NOT IN to use ANTI joins
Next
From: Heikki Linnakangas
Date:
Subject: Supporting Windows SChannel as OpenSSL replacement