two records per row from query

Поиск
Список
Период
Сортировка
От John
Тема two records per row from query
Дата
Msg-id 200908051651.13235.jfabiani@yolo.com
обсуждение исходный текст
Ответы Re: two records per row from query
Re: two records per row from query
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Create table command fails with permission denied
Следующее
От: "Klas Stockhem"
Дата:
Сообщение: Re: Problems when copy data from dump file