Postgres Pro
Downloads
Home   >   mailing lists

Re: How to read a sequence without incrementing it? - Mailing list pgsql-admin

From Pierre Couderc
Subject Re: How to read a sequence without incrementing it?
Date
Msg-id bipf5s$2p3m$1@news.hub.org
Whole thread Raw
In response to How to read a sequence without incrementing it?  (Pierre Couderc <pierre@couderc.cc>)
Responses Re: How to read a sequence without incrementing it?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: alexander v p
Date:
Subject: Re: eRserver
Next
From: "Marc G. Fournier"
Date:
Subject: Re: eRserver