am Tue, dem 03.04.2007, um 12:29:37 +0200 mailte Shavonne Marietta Wijesinghe folgendes: > 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() ??
Only to manipulate the current value of this sequence. > > For example i INSERT records via ASP. so i should put the setval() in the > INSERT INTO of the ASP page?? No. You can define your table like: create table foo (id serial, ...) This creates implicit a own sequence and set the default for id to nextval(). > And even when i do a SELECT i should use the setval()?? For a select? No. 12:39 < akretschmer> ??sequence 12:39 < rtfm_please> For information about sequence 12:39 < rtfm_please> see http://techdocs.postgresql.org/college/001_sequences/index.php 12:39 < rtfm_please> or http://www.postgresql.org/docs/current/interactive/sql-createsequence.html 12:39 < rtfm_please> or http://www.postgresql.org/docs/current/static/functions-sequence.html Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
