create table cth(id serial, rowid text, rowdt timestamp, attribute text, val text);               
insert into cth values(DEFAULT,'test1','01 March 2003','temperature','42');                       
insert into cth values(DEFAULT,'test1','01 March 2003','test_result','PASS');                     
insert into cth values(DEFAULT,'test1','01 March 2003','volts','2.6987');                         
insert into cth values(DEFAULT,'test2','02 March 2003','temperature','53');                       
insert into cth values(DEFAULT,'test2','02 March 2003','test_result','FAIL');                     
insert into cth values(DEFAULT,'test2','02 March 2003','test_startdate','01 March 2003');         
insert into cth values(DEFAULT,'test2','02 March 2003','volts','3.1234');                         
                                                                                                  
SELECT * FROM crosstab                                                                            
(                                                                                                 
  'SELECT rowid, rowdt, attribute, val FROM cth ORDER BY 1',                                      
  'SELECT DISTINCT attribute FROM cth ORDER BY 1'                                                 
)                                                                                                 
AS                                                                                                
(                                                                                                 
       rowid text,                                                                                
       rowdt timestamp,                                                                           
       temperature int4,                                                                          
       test_result text,                                                                          
       test_startdate timestamp,                                                                  
       volts float8                                                                               
);                                                                                                
 rowid |          rowdt           | temperature | test_result |      test_startdate      | volts  
 -------+--------------------------+-------------+-------------+--------------------------+--------
 
 test1 | Sat Mar  01   00 : 00 : 00   2003  |           42  | PASS        |                          |  2 . 6987  
 test2 | Sun Mar  02   00 : 00 : 00   2003  |           53  | FAIL        | Sat Mar  01   00 : 00 : 00   2003  |  3 . 1234  
( 2  rows)