Re: currval() in insert statements

Поиск
Список
Период
Сортировка
От Onno Molenkamp
Тема Re: currval() in insert statements
Дата
Msg-id 200902141450.22635.onno@flox.org
обсуждение исходный текст
Ответ на Re: currval() in insert statements  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-general
Hi,

I know that, and nextval -is- being called because it's the default value of
column "a". The problem is that apparently the order in which it's called has
changed for the form with a select, not that I don't know the difference
between currval and nextval.

Onno

Op Saturday 14 February 2009 14:41:44 schreef Grzegorz Jaśkiewicz:
> nextval.
> currval only has value, when sequence wwas used in the session before,
> you would use it to obtain last value returened by nextval. read the
> manual .


Вложения

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

Предыдущее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: currval() in insert statements
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: select max from subquery