| From: | Thomas Swan <tswan-lst(at)ics(dot)olemiss(dot)edu> |
|---|---|
| To: | "Josh Berkus" <josh(at)agliodbs(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Serials |
| Date: | 2001-01-12 22:02:42 |
| Message-ID: | 5.0.2.1.0.20010112150114.01a2a948@tangent.ics.olemiss.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
At 1/12/2001 10:35 AM, Josh Berkus wrote:
>Mr. Naik,
>
> > What's the purpose of Serials in Data types of postgres ?
> > TIA
> > Sharmad
SERIAL is the same as makeing a column and then setting the default value
to a sequence. If you insert and don't specify the column that is of type
serial it will have a new unique value on each insert. The datatype in a
serial
column is an int4.
>This topic is more than adequately covered in both the
>online documentation and Bruce Momjian's book. If language
>or other problems are preventing you from finding the
>correct reference, please reply and I'll give you a pointer.
>Othervwise, RTFM.
These things are explained with little effort. Granted sometimes these
are easily answered by consulting documentation, but sometimes all
anyone is looking for is a simple, quick answer.
Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rolf Johansson | 2001-01-13 10:42:56 | new serial type |
| Previous Message | Josh Berkus | 2001-01-12 17:02:13 | PL/PGSQL Array Parameters |