return column id from insert

From: Rory Campbell-Lange <mail(at)campbell-lange(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: return column id from insert
Date: 2002-11-12 11:50:34
Message-ID: 20021112115034.GB17654@campbell-lange.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I asked a question about this earlier, and didn't get a response I
understood!

The issue is this:
I need to make a database insert and then make an image with the
resulting column id number, which is provided by a sequence.

This has to be a single action, otherwise I could fall into a race
condition with another insert going on concurrently.

Any help much appreciated.

Thanks
Rory

--
Rory Campbell-Lange
<rory(at)campbell-lange(dot)net>
<www.campbell-lange.net>

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Simon Kelly 2002-11-12 12:02:36 oidin error when parsing XML documents
Previous Message cristi 2002-11-12 10:53:15 Re: SQL