Re: Serial

From: "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Serial
Date: 2007-04-03 10:29:37
Message-ID: 00e101c775da$fce4ec90$1102a8c0@dream
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • Re: Serial at 2007-04-03 10:14:46 from A. Kretschmer

Responses

  • Re: Serial at 2007-04-03 10:40:12 from A. Kretschmer

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2007-04-03 10:40:12 Re: Serial
Previous Message A. Kretschmer 2007-04-03 10:14:46 Re: Serial