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

> -----Original Message-----
> From: Philippe Lang [mailto:philippe.lang@xxxxxxxxxxxxxx] 
> Sent: 09 April 2004 13:33
> To: jorgens@xxxxxxxx; pgsql-odbc@xxxxxxxxxxxxxx
> 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.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend