Re: JDBC keygen select

Hi, Dave,

Dave Cramer wrote:
> Mike,
>
> Apparently there is a patch floating around that will implement INSERT
> ... RETURNING
>
> So I'd say that it is more likely that number 1 gets implemented as it
> would seem to me easier to do if we know exactly which column to return.

I'd also prefer that second way, as it additionally allows returing more
than one column (as a resultset), especially together with the multi-row
insert extension that's also discussed.

>> ps = itsDBConnection.prepareStatement(sql, {"myKeyColumn"});

ps = itsDBConnection.prepareStatement(sql+" RETURNING myKeyColumn");

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org