http://php.net/pg_getlastoid This is the *ONLY* time you should actually use OIDs -- To get the unique value you just inserted.
-- WARNING [EMAIL PROTECTED] address is an endangered species -- Use [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
