Skip site navigation (1) Skip section navigation (2)

@@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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group