Hosting Provided By

Re: [NOVICE] Obtaining the primary key of the record just inserted

From: Hans-Peter Oeri <hp(at)oeri.ch>
Date: Thu Nov 08 2007 - 14:24:49 EST

Hi!

Oliveiros Cristina wrote:
> I have the need to know the primary key assigned to a record I've just
> INSERTed .
> Is there an easy way to solve this ?

I prefer:
INSERT INTO [...] RETURNING id;

HPO Received on Thu Nov 8 14:27:55 2007

This message: [ Message body ]
Next message: David Monarchi: "[NOVICE] Constructing two-dimensional arrays from a query"
Previous message: Sean Davis: "Re: [NOVICE] Obtaining the primary key of the record just inserted"
In reply to: Oliveiros Cristina: "[NOVICE] Obtaining the primary key of the record just inserted"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Thu Jun 19 2008 - 00:03:43 EDT