| From: | Roy Sigurd Karlsbakk <roy(at)christianianett(dot)no> |
|---|---|
| To: | "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | The use of sequences |
| Date: | 1998-08-18 14:40:16 |
| Message-ID: | 35D9924F.3506064E@christianianett.no |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Could somebody tell me how I can make efficient use of sequences? I am
familiar with Oracle's sequences and they usually work as the following
example:
INSERT INTO PERSON table(some_sequence.nextval,data,data,data);
How do they work in postgreSQL?
Roy
--
Roy Sigurd Karlsbakk - MCSE, CNE, CLS, ASE - <roy(at)christianianett(dot)no>
ChristianiaNett A/S, Akersgt. 11, 0158 OSLO, +47 2247 3100
http://www.christianianett.no/ (norwegian)
| Attachment | Content-Type | Size |
|---|---|---|
| roy.vcf | text/x-vcard | 204 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Herouth Maoz | 1998-08-18 15:27:20 | Re: [GENERAL] The use of sequences |
| Previous Message | Rostislav Matl | 1998-08-18 14:21:39 | S-Designor definition file for PostgreSQL, alpha release |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Herouth Maoz | 1998-08-18 15:27:20 | Re: [GENERAL] The use of sequences |
| Previous Message | Herouth Maoz | 1998-08-17 09:28:52 | Re: [SQL] function year! |