| From: | Lone Wolf <hubaghdadi(at)yahoo(dot)ca> |
|---|---|
| To: | rod(at)iol(dot)ie |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Using sequences in SQL text files |
| Date: | 2008-02-19 15:54:29 |
| Message-ID: | 883119.53700.qm@web51107.mail.re2.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Can I have something like this in my SQL text file:
(items_seq.nextval(), '....', '...')
?
Raymond O'Donnell <rod(at)iol(dot)ie> wrote: On 19/02/2008 15:43, HHB wrote:
> How to use a sequence in such text files?
You're looking for the nextval() function - look it up in the docs.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------
Deep into that darkness peering, long I stood there, wondering, fearing, Doubting, dreaming dreams no mortal ever dreamed before.
E.A Poe
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-02-19 15:55:14 | Re: Using sequences in SQL text files |
| Previous Message | Raymond O'Donnell | 2008-02-19 15:51:46 | Re: Using sequences in SQL text files |