Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA46282 for ; Fri, 26 Mar 1999 11:29:04 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id KAA10610; Fri, 26 Mar 1999 10:29:02 -0600 (CST) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma010333; Fri, 26 Mar 99 10:28:40 -0600 Received: by cpsmail.cpsgroup.com with Internet Mail Service (5.5.2448.0) id ; Fri, 26 Mar 1999 10:29:18 -0600 Message-ID: From: "Jackson, DeJuan" To: The Hermit Hacker , pgsql-sql@postgreSQL.org Subject: RE: [SQL] Odd "problem", not sure if there is a solution .... Date: Fri, 26 Mar 1999 10:29:17 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" It's possible, but not on the SQL end. You'll have to do the work on the display end. If you're using PHP or Perl I'd be happy to give you a hand. -DEJ > -----Original Message----- > From: The Hermit Hacker [mailto:scrappy@hub.org] > Sent: Thursday, March 25, 1999 9:47 PM > To: pgsql-sql@postgreSQL.org > Subject: [SQL] Odd "problem", not sure if there is a solution .... > > > > 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 > >