Re: getting back autonumber just inserted

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: getting back autonumber just inserted
Дата
Msg-id 20050708014950.GA3339@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: getting back autonumber just inserted  (PFC <lists@boutiquenumerique.com>)
Ответы Re: getting back autonumber just inserted  (PFC <lists@boutiquenumerique.com>)
Re: getting back autonumber just inserted  (Larry Meadors <larry.meadors@gmail.com>)
Список pgsql-sql
On Fri, Jul 08, 2005 at 01:56:26AM +0200, PFC wrote:
> >Do you mean with lastval()?  Here's what happens:
> 
> Hm, interesting, you mean the return value of lastval() also depends 
> if  you set your constraints  to deferred or immediate ?

My mind's ablank trying to contrive a situation where that would
matter.  Can you provide an example?

In any case, I simply meant to point out that 8.1's lastval() will
be seductively convenient because you don't have to pass it a
sequence name, but the value it returns might not be the value you
want.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


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

Предыдущее
От: PFC
Дата:
Сообщение: Re: getting back autonumber just inserted
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Make COUNT(*) Faster?