Re: How to read a sequence without incrementing it?

Поиск
Список
Период
Сортировка
От Pierre Couderc
Тема Re: How to read a sequence without incrementing it?
Дата
Msg-id bipf5s$2p3m$1@news.hub.org
обсуждение исходный текст
Ответ на How to read a sequence without incrementing it?  (Pierre Couderc <pierre@couderc.cc>)
Ответы Re: How to read a sequence without incrementing it?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-admin
Thank you all.

SELECT last_value FROM my_sequence;

is the good solution.

(Currval() does not work as there is no nextval() before in the session)


Pierre Couderc


Pierre Couderc wrote:
> I would like to read the current value of a sequence, or a value not too
> far of the current value (for example, the value it was a few seconds or
> minutes ago). Is it possible (without any nexrval that should increment
> it)?
>
> Thank you all
>
> Pierre Couderc
>


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

Предыдущее
От: alexander v p
Дата:
Сообщение: Re: eRserver
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: eRserver