Re: Auto_Increment
| От | Jason Hihn |
|---|---|
| Тема | Re: Auto_Increment |
| Дата | |
| Msg-id | NGBBLHANMLKMHPDGJGAPOEFHCMAA.jhihn@paytimepayroll.com обсуждение исходный текст |
| Ответ на | Auto_Increment (Stephane Pinel <spinel@noos.fr>) |
| Список | pgsql-novice |
SERIAL
Though, there is a small change - this will create a sequence for you, and
in MySQL you could get the value that it assigned.
In Posgres you have to begin a transaction, insert the record, select
CURRVAL('sequence_name'); {read result} then commit the transaction.
> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Stephane Pinel
> Sent: Saturday, August 09, 2003 10:44 AM
> To: pgsql-novice@postgresql.org
> Subject: [NOVICE] Auto_Increment
>
>
> What is the pgsql equivalent keyword for the MySQL auto_increment
> keyword ?
>
> Thanks.
>
> Regards.
>
> Stephane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
В списке pgsql-novice по дате отправления: