it perhaps a bad idea to change "order" attribute for all the
records. So, IMHO, you'd better make the order as varchar(20),
so that you can insert anything between any two records.
hope this helps.
>From: "Shawn T. Walker" <shawn@netcrafters.com>
>To: pgsql-general@postgreSQL.org
>Subject: [GENERAL] Auto Ordering
>Date: Wed, 27 Oct 1999 13:17:21 -0400 (EDT)
>
>Hi All,
>
>I have a table of questions to be displayed to the user.
>
>Table: questions
>question_id SERIAL
>page int
>order int
>question varchar(100)
>answers text
>
>The field order is how the questions are sorted. How can I change change
>question 5 to be number one and have all the other questions re-order
>themselves?
>
>Thanks in advance.
>Shawn
>
>-------
>Shawn T. Walker <---> shawn@netcrafters.com
>
>
>
>
>
>************
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com