From: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
To: pgsql-sql@postgresql.org
Subject: Re: Serial
Date: Tue, 3 Apr 2007 12:29:37 +0200
Message-ID: <00e101c775da$fce4ec90$1102a8c0@dream> (raw)
References: <008301c775d1$4b224420$1102a8c0@dream>
<20070403093222.GB30108@a-kretschmer.de>
<00b101c775d6$2d313840$1102a8c0@dream>
<20070403101446.GC30108@a-kretschmer.de>
I'm mixed up now. I was suppose to something but i did something else.
OK so i have my FAMOUS table with the n_gen serial NOT NULL
I got lost a bit. When and where do i use the setval() ??
For example i INSERT records via ASP. so i should put the setval() in the
INSERT INTO of the ASP page??
And even when i do a SELECT i should use the setval()??
SELECT setval(N_GEN) FROM MyTable ORDER BY N_GEN::INT DESC
??
Shavonne Wijesinghe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shavonne.marietta@studioform.it
Subject: Re: Serial
In-Reply-To: <00e101c775da$fce4ec90$1102a8c0@dream>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox