| From: | "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL <pgsql-sql(at)postgresql(dot)org>, Pgadmin-Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Alternative Serial |
| Date: | 2007-03-11 14:20:33 |
| Message-ID: | 55c095e90703110720o78dfcfeai2b31bbadf17582b7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-sql |
Hi list,
I know that serials must be created like this.
Create the Serial
Create a field table and reffers to the pre-created serial.
Now I noticed that it is possible to use the default value. I am almost
quite sure that this is an alternative way and non polite.
I would like to know if I am correct and what does it means:
nextval('mySerial_id'::regclass)
What is regclass ?
Regards ,
--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ezequias Rodrigues da Rocha | 2007-03-11 14:32:07 | Re: On 19010 pgAdmin doesn't run |
| Previous Message | Andy Shellam | 2007-03-11 13:47:54 | Re: On 19010 pgAdmin doesn't run |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Milen A. Radev | 2007-03-11 14:47:52 | Re: Alternative Serial |
| Previous Message | Jeff Davis | 2007-03-10 01:16:13 | Re: Statistics |