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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
