Postgres Pro
Downloads
Home   >   mailing lists

Re: Use of array_agg and array string on inner query - Mailing list pgsql-general

From David G. Johnston
Subject Re: Use of array_agg and array string on inner query
Date
Msg-id CAKFQuwY7hZyc3ipgkT_VV+bsa0Mp_5qcx=33wPuSiDVoSUr+KQ@mail.gmail.com
Whole thread Raw
In response to Re: Use of array_agg and array string on inner query  (shankha <shankhabanerjee@gmail.com>)
Responses Re: Use of array_agg and array string on inner query  (shankha <shankhabanerjee@gmail.com>)
List pgsql-general
Tree view
On Wed, May 18, 2016 at 2:30 PM, shankha <shankhabanerjee@gmail.com> wrote:
I cannot move the array_agg to around the column name. It has to work
as a inner query
​.

​The following form is used to make an array from a subquery:

SELECT ARRAY(SELECT i FROM ( VALUES (1), (2), (3) ) vals (i) );​
​
​


4.2.12; last example

Not the most obvious place...

David J.​


pgsql-general by date:

Previous
From: shankha
Date:
Subject: Re: Use of array_agg and array string on inner query
Next
From: Leonardo M. Ramé
Date:
Subject: Londiste 3 pgq events_1_1 table huge