two records per row from query - Mailing list pgsql-sql

From John
Subject two records per row from query
Date
Msg-id 200908051651.13235.jfabiani@yolo.com
Whole thread Raw
Responses Re: two records per row from query  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: two records per row from query  (Leo Mannhart <leo.mannhart@beecom.ch>)
List 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Create table command fails with permission denied
Next
From: "Klas Stockhem"
Date:
Subject: Re: Problems when copy data from dump file