Re: Selecting Current value from a sequence - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Selecting Current value from a sequence
Date
Msg-id 200101181823.NAA28799@candle.pha.pa.us
Whole thread Raw
In response to Selecting Current value from a sequence  (Najm Hashmi <najm@mondo-live.com>)
List pgsql-sql
See my book on sequences:
http://www.postgresql.org/docs/awbook.html

currval() is probably what you need.

> Hi all,
>  It is a very simple but I am not able to recall  how to do it.... I
> just need to find out the  current value of a seq. It is very simple
> select statement but I can't recall it... Help me please before I get
> myself get fired -:).
> Regards, Najm
> 
> 


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: clayton cottingham
Date:
Subject: Re: Selecting Current value from a sequence
Next
From: Patrick Welche
Date:
Subject: Re: [GENERAL] Help with query. (*)