getting back autonumber just inserted

Поиск
Список
Период
Сортировка
От mail TechEvolution
Тема getting back autonumber just inserted
Дата
Msg-id 42CD6B58.6060508@techevolution.be
обсуждение исходный текст
Ответы Re: getting back autonumber just inserted
Re: getting back autonumber just inserted
Список pgsql-sql
hello

i ame a newbie to PostGreSQL, I ame using PostGreSQL 8.0 
(windowsinstaller) on a xp prof platform

i would like to get back the autonumber from the last record inserted, 
for other SQL db (m$ sql db ...) i could use:
SELECT @@ IDENTITY

can someone help me by informing me what the SQL syntax is to be used 
with PostGreSQL db and get the same result, the last autonumber inserted?

greeTz

wes


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