Re: Selecting Current value from a sequence

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Selecting Current value from a sequence
Дата
Msg-id 200101181823.NAA28799@candle.pha.pa.us
обсуждение исходный текст
Ответ на Selecting Current value from a sequence  (Najm Hashmi <najm@mondo-live.com>)
Список 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 по дате отправления:

Предыдущее
От: clayton cottingham
Дата:
Сообщение: Re: Selecting Current value from a sequence
Следующее
От: Patrick Welche
Дата:
Сообщение: Re: [GENERAL] Help with query. (*)