Auto Ordering

From: "Shawn T(dot) Walker" <shawn(at)netcrafters(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Auto Ordering
Date: 1999-10-27 17:17:21
Message-ID: Pine.LNX.3.95.991027131111.23280B-100000@bigboy.netcrafters.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)netcrafters(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1999-10-27 17:21:03 Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL?
Previous Message Bruce Momjian 1999-10-27 16:27:30 Re: [GENERAL] Windows Server?