@@IDENTITY

From: Mike Fahey <mfahey(at)enter(dot)net>
To: Postgres list <pgsql-odbc(at)postgresql(dot)org>
Subject: @@IDENTITY
Date: 2004-11-10 17:59:04
Message-ID: 419256E8.2070403@enter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


Does select @@IDENTITY work with version 8.0.02 ?

IT returns "2" every single time.

All I want to do is get the last inserted id from a sequence.

Suggestions?

--
With best regards,

Mike Fahey - Systems Administration
********************************************************************
ENTER.NET - "The Road to the Internet Starts Here!" (tm)
(610) 437-2221 * http://www.enter.net/ * email:support(at)enter(dot)net
********************************************************************

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Peter Eisentraut 2004-11-10 18:17:59 Re: @@IDENTITY
Previous Message Mike Fahey 2004-11-10 17:03:45 Can't use current_timestamp or currval functions