Postgres Pro
Downloads
Home   >   mailing lists

Odd "problem", not sure if there is a solution .... - Mailing list pgsql-sql

From The Hermit Hacker
Subject Odd "problem", not sure if there is a solution ....
Date
Msg-id Pine.BSF.4.05.9903252343280.389-100000@thelab.hub.org
Whole thread Raw
Responses Re: [SQL] Odd "problem", not sure if there is a solution ....  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-sql
Tree view 
am working up a database for client that contains answers for online
testing...right now, the 'tables' look like:

userid Q1 Q2 Q3 Q4 Q5 Q6 Q7 etc

I want to change it so that its more generic, as:

userid question_no answer

so that instead of one row per user, there are X rows...

the problem is that, somehow, I want the client to be able to view the
results as the first format (ie. one line per user) with it being stored
as multiple lines per user...

Possible?

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org

pgsql-sql by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Subselect has too many or too few fields
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Odd "problem", not sure if there is a solution ....