Postgres Pro
Downloads
Home   >   mailing lists

Re: It it possible to get this result in one query? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: It it possible to get this result in one query?
Date
Msg-id AANLkTinDoLfMdZ8MoW4fbpeabtA60qY6vZ+2Q6Gb6tkv@mail.gmail.com
Whole thread Raw
In response to Re: It it possible to get this result in one query?  (Nick <nboutelier@gmail.com>)
List pgsql-general
Tree view 
On Fri, Oct 15, 2010 at 2:55 AM, Nick <nboutelier@gmail.com> wrote:
> Thanks Guy, is it possible to get the 3rd column result as an array
> instead of string? -Nick

tbh, your solution using array_agg over union all upthread looked spot on...

merlin

pgsql-general by date:

Previous
From: Szymon Guz
Date:
Subject: Re: Strange phenomenon
Next
From: "Igor Neyman"
Date:
Subject: Re: how to write an optimized sql with two same subsql?