Search Postgresql Archives

Re: Dynamic multi dimensional arrays in SQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

I am afraid, so this functionality is supported only in unreleased PostgreSQL 9.5

postgres=# SELECT ARRAY(SELECT ARRAY[true::text,false::text] FROM generate_series(1,2));
┌─────────────────────────────┐
│            array            │
╞═════════════════════════════╡
│ {{true,false},{true,false}} │
└─────────────────────────────┘
(1 row)


It is one from new features there.

In previous versions you can to write own custom aggregate function.

Regards

Pavel Stehule


2015-07-10 16:52 GMT+02:00 Dane Foster <studdugie@xxxxxxxxx>:
Hello,

I'm trying to dynamically construct a multi dimensional array where the outer most array's elements are binary arrays. My initial attempt was something to the effect of:
SELECT ARRAY(SELECT ARRAY[true::text,false::text] FROM generate_series(1,2));

My expectation is a result of the form: {{true,false},{true,false}}

But it doesn't work. I get the following error instead: "could not find array type for data type text[]".

The only way I've gotten it to work is to concatenate strings and explicitly cast the string to an array. It's ugly. I'm hoping the issue is that I'm doing something wrong and not that string concatenation or a procedural language are the only solutions.

Any insight into what I'm doing wrong would be appreciated.

Regards,

Dane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux