Re: kinda newbie - ish question

From: "Richard Lynch" <ceo(at)l-i-e(dot)com>
To: "Mike Judkins" <mmacie(at)earthlink(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: kinda newbie - ish question
Date: 2001-10-11 17:24:07
Message-ID: 000701c152bc$6c300460$c801a8c0@Lynchux100
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

http://php.net/pg_getlastoid

This is the *ONLY* time you should actually use OIDs -- To get the unique
value you just inserted.

--
WARNING richard(at)zend(dot)com address is an endangered species -- Use
ceo(at)l-i-e(dot)com
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm
----- Original Message -----
From: Mike Judkins <mmacie(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Monday, October 08, 2001 9: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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gaurav Priyolkar 2001-10-11 17:36:40 "Relation x does not exist" error when x does exist
Previous Message Bruce Momjian 2001-10-11 16:54:22 Re: psql and security