PG Doc comments form writes:
> I have PostgreSQL 13. Let's declare the type below, then use it in
> pl/pgsql:
> create type typ1 as (
> fld1 int[][]
> );
I think you have a fundamental misunderstanding of how multidimensional
arrays work in Postgres. There's no separate type for 2-D vs 1-
Hi
čt 29. 4. 2021 v 12:33 odesílatel Rafal Dabrowa
napsal:
> This also returns ERROR: invalid input syntax for type integer:
> "[221,222,223,224]"
>
> On 4/29/2021 9:48 AM, KraSer wrote:
> > try:
> > a.fld1[1] = '[221,222,223,224]';
> >
> > чт, 29 апр. 2021 г. в 10:35, PG Doc comments form
> >
This also returns ERROR: invalid input syntax for type integer:
"[221,222,223,224]"
On 4/29/2021 9:48 AM, KraSer wrote:
try:
a.fld1[1] = '[221,222,223,224]';
чт, 29 апр. 2021 г. в 10:35, PG Doc comments form
mailto:nore...@postgresql.org>>:
The following documentation comment has been
try:
a.fld1[1] = '[221,222,223,224]';
чт, 29 апр. 2021 г. в 10:35, PG Doc comments form :
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/13/arrays.html
> Description:
>
> I have PostgreSQL 13. Let's declare the type below, then use
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/arrays.html
Description:
I have PostgreSQL 13. Let's declare the type below, then use it in
pl/pgsql:
create type typ1 as (
fld1 int[][]
);
do $$
declare
a typ
