From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
---|---|
To: | "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: getGeneratedKeys() |
Date: | 2003-12-30 23:56:23 |
Message-ID: | 20031230235623.A27715@bacon |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On 30/12/2003 23:18 henr-and(at)dsv(dot)su(dot)se wrote:
> > Can you do the insert using a function instead, and return the currval
> > on the underlying sequence?
> >
> > John
> >
>
> I'm not sure what you mean. A stored procedure?
>
> The good thing about getGeneratedKeys() is that you don't have to write
> DB-specific code.
I always thought that auto-generated keys _are_ db specific. Where are
they defined in SQL92/99?
Back to your problem: Does your app have to support different DBMSs or is
it PostgreSQL-only?
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | henr-and | 2003-12-31 00:08:14 | Re: getGeneratedKeys() |
Previous Message | Marcus Andree S. Magalhaes | 2003-12-30 23:28:21 | Re: getGeneratedKeys() |