Re: kinda newbie - ish question

Use select nextval('sequence_name') to get the unique ID from the sequence,
then put it in both queries via a PHP variable.

----- Original Message -----
From: "Mike Judkins" <mmacie(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Monday, October 08, 2001 10:31 PM
Subject: [GENERAL] kinda newbie - ish question

> hi all,
>
> Im trying to insert a record with a php script. I insert a NULL value
> to get my auto increment unique key to automatically populate as
> usual. Then I want to be able to insert another value in this same row
> which is a URL. This URL is basically a path plus a filename which I
> want to have the exact same name as the unique key that was just
> generated for the row. Is there a quick way is SQL to do this or will
> I have to handle it in my script?
>
> Thanks for helping!
>
> Mike
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>