Re: nooby q: how get a row just inserted?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: nooby q: how get a row just inserted?
Дата
Msg-id dcc563d10905301755y1497011dv1e45e9c3b7c35c75@mail.gmail.com
обсуждение исходный текст
Ответ на Re: nooby q: how get a row just inserted?  (Kenneth Tilton <kentilton@gmail.com>)
Список pgsql-general
On Sat, May 30, 2009 at 6:52 PM, Kenneth Tilton <kentilton@gmail.com> wrote:
>
>
> Martin Gainty wrote:
>>
>> yes i would suggest using OID
>> included in Postgres distro is a sample create table,index named
>> fti.pl
>>
>> does this answer your question?
>
> oid would have been fine, but I am going with Rodrigo's suggestion to simply
> use the returning option on insert which I somehow missed.

One of the cool features of returning is that it can return sets.

insert into table values ('abc'),('def'),('ghi') returning id;
1
2
3

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

Предыдущее
От: Kenneth Tilton
Дата:
Сообщение: Re: nooby q: how get a row just inserted?
Следующее
От: Wojtek
Дата:
Сообщение: PG_Bulkloader (or other tools) and partitions