Re: getting back autonumber just inserted

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: getting back autonumber just inserted
Дата
Msg-id 20050714130517.GA11501@wolff.to
обсуждение исходный текст
Ответ на Re: getting back autonumber just inserted  (Larry Meadors <larry.meadors@gmail.com>)
Список pgsql-sql
On Thu, Jul 07, 2005 at 14:47:23 -0600, Larry Meadors <larry.meadors@gmail.com> wrote:
> If you have a trigger on your table that inserts a record in a table
> and shares the same sequence, what value do you get back, the
> triggered curval, or the currently inserted one?

Whichever one was done second. I think it has to be the trigger, because
I think the inserted values will be evaluated first (even before aa
before trigger) since the triggers need to have access to them.


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Possible to use a table to tell what table to select from?
Следующее
От: sunny076@yahoo.com
Дата:
Сообщение: How to obtain the list of data table name only