Re: kinda newbie - ish question

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(at)earthlink(dot)net [mailto:mmacie(at)earthlink(dot)net]
> Sent: Monday, October 08, 2001 9:32 PM
> To: pgsql-general(at)postgresql(dot)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
>