Re: Is _ a supported way to create a column of array type?

2019-04-26 Thread Piotr Findeisen
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

Re: Is _ a supported way to create a column of array type?

2019-04-26 Thread Piotr Findeisen
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

Is _ a supported way to create a column of array type?

2019-04-25 Thread Piotr Findeisen
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