From: | John <jfabiani(at)yolo(dot)com> |
---|---|
To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | two records per row from query |
Date: | 2009-08-05 23:51:13 |
Message-ID: | 200908051651.13235.jfabiani@yolo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
mytable
pkid
class_date.
sessionid
select * from mytable
1 2009/01/01 2101
2 2009/01/02 2101
I would like an SQL that would produce
newtable
pkid,
class_date1,
class_date2,
sessionid1,
sessionid2
Select * from newtable
1 2009/01/01 2009/01/02 2101 2101
I have a list of classes that is perfect for our needs. However, I need to
create the second table (from a query) to feed to a report writer so it can
write out a single line of text for two records.
Like:
Your class dates are as follows
Date Date
01/01/2009 01/02/2009
01/08/2009 01/10/2009
03/31/2009 04/05/2009
and will continue until the all the classes are printed.
The problem of course is the table has a row per class and the report writer
needs two class dates per row.
I have no idea how to do this using SQL.
Thanks in advance,
Johnf
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-08-06 02:19:53 | Re: LOG: unexpected EOF on client connection |
Previous Message | Bernd Nawothnig | 2009-08-05 18:40:19 | Re: LOG: unexpected EOF on client connection |