Postgres Pro
Downloads
Home   >   mailing lists

Re: is there a way to deliver an array over column from a query window? - Mailing list pgsql-general

From Tom Lane
Subject Re: is there a way to deliver an array over column from a query window?
Date
Msg-id 12182.1366989941@sss.pgh.pa.us
Whole thread Raw
In response to Re: is there a way to deliver an array over column from a query window?  (Rafał Pietrak <rafal@ztk-rp.eu>)
Responses Re: is there a way to deliver an array over column from a query window?
List pgsql-general
Tree view 
=?ISO-8859-2?Q?Rafa=B3_Pietrak?= <rafal@ztk-rp.eu> writes:
> array_agg(distinct v order by v) -- works in postgres, but actually I need:
> array_agg(distinct v order by v,x) -- which doesn't. (ERROR:
> ....expressions must appear in argument list),

Why do you think you need that?  AFAICS, the extra order-by column could
not in any way affect the result of the operation.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: apt.postgresql.org broken dependency?
Next
From: salah jubeh
Date:
Subject: Re: Table containing only valid table names