Re: Serial - Mailing list pgsql-sql

From Shavonne Marietta Wijesinghe
Subject Re: Serial
Date
Msg-id 00e101c775da$fce4ec90$1102a8c0@dream
Whole thread Raw
In response to Serial  ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
Responses Re: Serial  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
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 



pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Serial
Next
From: "A. Kretschmer"
Date:
Subject: Re: Serial