Mike,
Perhaps you could just insert the url into the record and then
use a string function to return "url"+"id" when needed. This would
eliminate the extra insert and save space in the row.
Dale
> -----Original Message-----
> From: mmacie@earthlink.net [mailto:mmacie@earthlink.net]
> Sent: Monday, October 08, 2001 9:32 PM
> To: pgsql-general@postgresql.org
> 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
>