On 20/05/2009 11:17, A. Kretschmer wrote: > In response to David : >> Hi there. >> >> I never found an adequate (simple and efficient) method for getting >> the primary key ID of the just-inserted row, and usually used >> transactions and "select last value, ordered by id"-type queries to >> get the last id value, or other ugly logic. > > use currval() instead, see > http://www.postgresql.org/docs/current/static/functions-sequence.html Also, you can do insert....returning... (as of version 8.2, I think): INSERT INTO clients (id, name) VALUES (nextval('clients_id_seq'), 'John Smith') RETURNING id; Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
