Auto Ordering - Mailing list pgsql-general

From Shawn T. Walker
Subject Auto Ordering
Date
Msg-id Pine.LNX.3.95.991027131111.23280B-100000@bigboy.netcrafters.com
Whole thread Raw
Responses Re: [GENERAL] Auto Ordering
Re: [GENERAL] Auto Ordering
Re: [GENERAL] Auto Ordering
List 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@netcrafters.com





pgsql-general by date:

Previous
From: big.john@bigfoot.com
Date:
Subject: create index on numeric
Next
From: Ted Nolan SRI Augusta GA
Date:
Subject: Re: [GENERAL] Windows Server?