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

From Priya G
Subject Re: How to read a sequence without incrementing it?
Date
Msg-id BAY2-F30CPx33E1ioWw0000b1ad@hotmail.com
Whole thread Raw
In response to How to read a sequence without incrementing it?  (Pierre Couderc <pierre@couderc.cc>)
List pgsql-admin

select last_value from 'seq';

>From: Pierre Couderc
>To: pgsql-admin@postgresql.org
>Subject: [ADMIN] How to read a sequence without incrementing it?
>Date: Fri, 29 Aug 2003 18:27:09 +0200
>
>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
>
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster


Get MSN 8 and enjoy automatic e-mail virus protection.

pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: How to read a sequence without incrementing it?
Next
From: "Haron, Charles"
Date:
Subject: Define function with no return value?