Re: getting back autonumber just inserted

Поиск
Список
Период
Сортировка
От Edmund Bacon
Тема Re: getting back autonumber just inserted
Дата
Msg-id 4202AB60.90608@onesystem.com
обсуждение исходный текст
Ответ на Re: getting back autonumber just inserted  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-sql
Perhaps you meant:
http://www.postgresql.org/docs/8.0/interactive/functions-info.html#FUNCTIONS-INFO-SCHEMA-TABLE

in particular  |pg_get_serial_sequence|(table_name, column_name)



Sean Davis wrote:

>
> On Feb 3, 2005, at 5:16 PM, lorid wrote:
>
>> I could have sworn I kept a copy of prior emails that discussed how 
>> to  get back a value that was just inserted into a autonumber (or in  
>> postgresql case a sequence number)
>>
>
> See here:
>
> http://www.postgresql.org/docs/8.0/interactive/functions- 
> sequence.html#FUNCTIONS-SEQUENCE-TABLE
>
> Sean
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


-- 
Edmund Bacon <ebacon@onesystem.com>



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

Предыдущее
От: Sean Davis
Дата:
Сообщение: Re: getting back autonumber just inserted
Следующее
От: Don Drake
Дата:
Сообщение: Determining Rank