Re: [GENERAL] Dynamic multi dimensional arrays in SQL

2015-07-10 Thread Pavel Stehule
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

[GENERAL] Dynamic multi dimensional arrays in SQL

2015-07-10 Thread Dane Foster
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: {{