From: | "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Row ID and auto-increment? |
Date: | 2001-02-20 15:34:20 |
Message-ID: | 20010220153420.3632.qmail@web310.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
You can create an auto incrementing field with SERIAL. Take a
look at the FAQ
(http://www.postgresql.org/docs/faq-english.html#4.16.1)
Brent
--- Raymond Chui <raymond(dot)chui(at)noaa(dot)gov> wrote:
> If I create a table like
>
> create table tablename (
> aNum integer not null,
> name varchar(10)
> );
>
> If I do select * from tablename;
>
> q1. Is there such thing rowid similar to Oracle in PostgreSQL?
> q2. How do I make aNum auto increment by 1? Need to write
> a trigger? how to write that?
> I want to enforce column aNum 0,1,2,.....n.
> I want to prevent data entry people input 0,1,4,5,8,...n.
> Thank you very much in advance!
>
>
>
>
> --Raymond
>
> > begin:vcard
> n:Chui;Raymond
> tel;fax:(301)713-0963
> tel;work:(301)713-0624 Ext. 168
> x-mozilla-html:TRUE
> url:http://members.xoom.com/rchui/
> org:NWS, NOAA
> version:2.1
> email;internet:Raymond(dot)Chui(at)noaa(dot)gov
> title:SA, DBA
> note:ICQ #: 16722494
> adr;quoted-printable:;;NOAA, NWS, Office of Hydrology,
> OH=0D=0A1325 East-West Highway, Room 8112;Silver
> Spring;MD;20910-3283;U.S.A.
> x-mozilla-cpt:;-6384
> fn:Raymond Chui
> end:vcard
>
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Brent R. Matzelle | 2001-02-20 15:36:12 | Re: max / min explain |
Previous Message | Bruce Momjian | 2001-02-20 15:32:21 | Re: vacuum analyze again... |