Re: It it possible to get this result in one query?

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Nick <nboutelier(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: It it possible to get this result in one query?
Date: 2010-10-15 17:39:22
Message-ID: AANLkTinDoLfMdZ8MoW4fbpeabtA60qY6vZ+2Q6Gb6tkv@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 15, 2010 at 2:55 AM, Nick <nboutelier(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2010-10-15 17:56:25 Re: how to write an optimized sql with two same subsql?
Previous Message Szymon Guz 2010-10-15 16:53:33 Re: Strange phenomenon