: pgsql-general@postgresql.org
>> Subject: [GENERAL] Need help with SQL query and finding NULL
>> array_agg
>>
>> Hello ppl,
>>
>> I have a problem with one sql query, can some one help me. My
query
>> is:
>>
>> SELECT array_agg(month) AS month, arr
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Condor
> Sent: Thursday, August 02, 2012 4:35 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Need help with SQL query and findin
On 2012-08-01 23:59, David Johnston wrote:
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Condor
Sent: Wednesday, August 01, 2012 4:16 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Need help with SQL query
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Condor
> Sent: Wednesday, August 01, 2012 4:16 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Need help with SQL query and find
Hello ppl,
I have a problem with one sql query, can some one help me. My query is:
SELECT array_agg(month) AS month, array_agg(status) AS status,
array_agg(service) AS service, case when array_upper(array_agg(phone),
1) is not null THEN array_agg(phone) else array_agg(mobile) END FROM
bills W
