Maxim Boguk writes:
> PS: I try create two-dimentional integer array from query results:
Well, you could do that with a suitably defined aggregate having the
signature "agg(anyarray) returns anyarray". But array_agg has the
signature "array_agg(anyelement) returns anyarray" so you can't use
it
On Mon, Dec 5, 2011 at 2:05 PM, Tom Lane wrote:
> maxim.bo...@gmail.com writes:
> > SELECT ARRAY(SELECT ...)
> > doesn't work when subselect return any array.
> > Is that syntax supposed to work with anyarray types?
>
> No.
>
>regards, tom lane
>
Hi.
Thank you very much
maxim.bo...@gmail.com writes:
> SELECT ARRAY(SELECT ...)
> doesn't work when subselect return any array.
> Is that syntax supposed to work with anyarray types?
No.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your
The following bug has been logged on the website:
Bug reference: 6326
Logged by: Maksym Boguk
Email address: maxim.bo...@gmail.com
PostgreSQL version: 9.1.1
Operating system: Linux
Description:
SELECT ARRAY(SELECT ...)
doesn't work when subselect return any array.
T
