Getting OID after Insert

Поиск
Список
Период
Сортировка
От Bruce Cota
Тема Getting OID after Insert
Дата
Msg-id 3BCE4A13.F815847@vivi.com
обсуждение исходный текст
Ответы Re: Getting OID after Insert
Re: Getting OID after Insert
Список pgsql-general
Is there a way, in SQL, to access the oid of the row created
by an immediately preceding insert statement?

e.g.

insert into t (x, y) values (1, 2);

select * from t where oid = <what goes here?>

Thanks for any advice.

-Bruce


 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
                http://www.usenet.com

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