Re: kinda newbie - ish question
От | Mitch Vincent |
---|---|
Тема | Re: kinda newbie - ish question |
Дата | |
Msg-id | 008701c151c2$8ac22890$1e51000a@mitch обсуждение исходный текст |
Ответ на | kinda newbie - ish question (mmacie@earthlink.net (Mike Judkins)) |
Список | pgsql-general |
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@earthlink.net> To: <pgsql-general@postgresql.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 >
В списке pgsql-general по дате отправления: