Re: [GENERAL] script not working in php

2011-10-06 Thread Robert Buckley
Thankssimple but important! Von: Rodrigo Gonzalez An: Robert Buckley Cc: "pgsql-general@postgresql.org" Gesendet: 14:39 Donnerstag, 6.Oktober 2011 Betreff: Re: [GENERAL] script not working in php On 10/06/2011 09:22 AM, Robert Buckley

Re: [GENERAL] script not working in php

2011-10-06 Thread Rodrigo Gonzalez
On 10/06/2011 09:22 AM, 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_

Re: [GENERAL] script not working in php

2011-10-06 Thread Raymond O'Donnell
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, so

[GENERAL] script not working in php

2011-10-06 Thread Robert Buckley
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.te