Hi Tom,
I think I understand now.
Postgres type system does not distinguish between array types with different
number of dimensions. int[], int[][] and int[][][][][][] are all equivalent
to the type system.
Number of dimensions is part of the value though and execution takes care
of it.
If I sub
rrect value when
column is defined using _ form?
Best,
Piotr
On Thu, Apr 25, 2019 at 11:03 PM Tom Lane wrote:
> Piotr Findeisen writes:
> > Internally, array types get a name in the form of `_`.
>
> Typically, yes.
>
> > *Can a user use `_` to define a column of arr
Hi,
As documented to
https://www.postgresql.org/docs/11/arrays.html#ARRAYS-DECLARATION one can
create column of an array type using `[]` form.
Internally, array types get a name in the form of `_`.
This is documented
https://www.postgresql.org/docs/11/sql-createtype.html#id-1.9.3.94.5.9
*So -- t