Postgres Pro
Downloads
Home   >   mailing lists

getting currval from a sequence - Mailing list pgsql-general

From tony
Subject getting currval from a sequence
Date
Msg-id 1013424151.2089.24.camel@vaio
Whole thread Raw
Responses Re: getting currval from a sequence  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
Hello,

I would like to be able to get currval from a sequence but am running
ito the "current session" limitation.

I need to get the id of the previous record either during a session or
on a cold start (next morning for example).

How does one get the last record from a series of records? I just need
the id field which is a sequence field

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

pgsql-general by date:

Previous
From: "Carlo Florendo"
Date:
Subject: pg_hba.conf problem?
Next
From: Bruno Wolff III
Date:
Subject: Re: Function to Pivot data