Re: [Q] Sequences, last_value and inserts

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: [Q] Sequences, last_value and inserts
Дата
Msg-id m37kfx82gc.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на Re: [Q] Sequences, last_value and inserts  ("Roderick A. Anderson" <raanders@acm.org>)
Ответы Re: [Q] Sequences, last_value and inserts  ("Marie G. Tuite" <marie.tuite@edisonaffiliates.com>)
Re: [Q] Sequences, last_value and inserts  ("Roderick A. Anderson" <raanders@acm.org>)
Список pgsql-general
"Roderick A. Anderson" <raanders@acm.org> writes:

> On Fri, 1 Nov 2002, Bruno Wolff III wrote:
>
> > You want to use currval. This can be used within a single session safely.
>
> I must be thick today.
>
> select currval from domain_info_tbl_key_seq;
> ERROR:  Attribute 'currval' not found

Try:

select currval('domain_info_tbl_key_seq');

If you read the docs, you would know this.  ;)

-Doug

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

Предыдущее
От: "Roderick A. Anderson"
Дата:
Сообщение: Re: [Q] Sequences, last_value and inserts
Следующее
От: "Marie G. Tuite"
Дата:
Сообщение: Re: [Q] Sequences, last_value and inserts