two records per row from query

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

Responses

Browse pgsql-sql by date

  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