Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to firstname.lastname@example.org.
David Somers wrote: > Tony Hoyle wrote: >> Something like insert ... into sessionlog select >> currval('sessionlog_id_seq') > > The currval function is more for use in schema and SQL functions... and > there's still the problem that INSERT only returns the numer of rows > inserted rather than a field (which is what the RETURNING op does). oops... yep, you can do it as a separate select to get the id... its not method that I use a lot. I see you've committed a change... looks good... am testing now. David.