getting the currval of a sequence

From: Fran Fabrizio <fran(at)primary(dot)net>
To: pgsql-general(at)postgreSQL(dot)org
Subject: getting the currval of a sequence
Date: 1998-08-14 05:43:38
Message-ID: 3.0.5.32.19980814004338.00835da0@mail.primary.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all,

I need to do the equivalent of:

select my_sequence.CURRVAL from Sys.dual;

so I'm guessing its:

select currvar('my_sequence') from ???????;

Can anyone fill in the ???? Thanks!

-Fran

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dustin sallings 1998-08-14 06:09:31 Re: [GENERAL] getting the currval of a sequence
Previous Message Philippe Selo 1998-08-14 03:49:04 subscribe pgsql-general