Re: @@IDENTITY (Was: Access - ODBC - serial problem)

> -----Original Message-----
> From: Philippe Lang [mailto:philippe.lang@attiksystem.ch]
> Sent: 09 April 2004 13:33
> To: jorgens@coho.net; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Access - ODBC - serial problem...
>
> Is there a Postgresql ODBC driver guru that could give us an
> idea for a driver modification? I don't know the exact job of
> an ODBC driver, nor how it connects to Postgresql, so I
> cannot tell if it would be possible to modify the ODBC
> driver, and do something like a "SELECT @@IDENTITY" (which is
> a SQL Server 2000 call, correct).
>
> Since Microsoft is behind both Access and SQL Server, maybe
> nothing can be done in the driver itself, and I'll have to
> handle my insertions by hand, through pl/pgsql. But really,
> that's a serious limitation...

SELECT CURRENT_USER;

Though I suspect that is not what you want. Are you asking for the
driver to translate '@@IDENTITY' into 'CURRENT_USER'?

Regards, Dave.