Getting primary key from insert statement

Поиск
Список
Период
Сортировка
От Pham, Thinh
Тема Getting primary key from insert statement
Дата
Msg-id 551413BBBB03D111BF880060B01AACCE0B38FA@home.priority.net
обсуждение исходный текст
Ответы Re: [SQL] Getting primary key from insert statement
Re: [SQL] Getting primary key from insert statement
Список pgsql-sql
Hi, is there a way you can get back the primary key (serialized) from an
insert you just do on a table. For example i have a table called "order" and
i want to get the pid of that record so i can use it in the "orderdetail"
table. It would be nice if that same insert statement could also return the
pid.

Table structure:
create table order (pid serial, orddate date);
create table orderdetail (pid serial, orderpid int, name varchar(50));

Insert statement:
insert into order (date) values ('6/2/1999')

order table
pid    | orddate
----------------
1    | 6/2/1999

orderdetail table
pid    | orderpid    | name
--------------------------
1    | 1        | pencil
2    | 1        | pen

I know there must be a way, but i just couldn't find it in either the pgsql
docs or faq. Thanks in advance,
Thinh


В списке pgsql-sql по дате отправления:

Предыдущее
От: Jason Earl
Дата:
Сообщение: Re: [SQL] OUTER JOINs in PostgreSQL
Следующее
От: "Mark Wright"
Дата:
Сообщение: Are PL/pgSQL calls atomic?