On 06/10/2011 13:22, Robert Buckley wrote: > Hi, > > this works ok in pgadmin3 > > select name[i], kw[i] > from ( select generate_series(1,6) as i, > array['Biomasse', 'Deponiegas', 'Solar', 'Wasser', > 'Wind','GESAMT'] as name, > array[biomasse_kw, deponiegas_kw, solar_kw,wasser_kw, > wind_kw, kw] as kw > from energie.tennet_auswertung_pivot_energie ) z > ; > > but in the php script I get error 500? What does it say in the PHP log? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general