From: | Rodrigo Gonzalez <rjgonzale(at)estrads(dot)com(dot)ar> |
---|---|
To: | Robert Buckley <robertdbuckley(at)yahoo(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: script not working in php |
Date: | 2011-10-06 12:39:59 |
Message-ID: | 4E8DA19F.1000306@estrads.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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_kw,
> wind_kw, kw] as kw
> from energie.tennet_auswertung_pivot_energie ) z
> ;
>
> but in the php script I get error 500?
>
>
> $result = pg_query($connection,'
> 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
> ;
> ');
You have single quotes inside the query and the complete string is
defined with single quotes too.....use double quotes to define the string
Rodrigo
From | Date | Subject | |
---|---|---|---|
Next Message | Henry Drexler | 2011-10-06 12:40:34 | ts_rank error/result of '1e-020' |
Previous Message | Adarsh Sharma | 2011-10-06 12:31:19 | Re: Restoring 2 Tables From All Databases Backup |