Re: Possible mistake in new array syntax - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Possible mistake in new array syntax
Date
Msg-id 14345.1056759515@sss.pgh.pa.us
Whole thread Raw
In response to Possible mistake in new array syntax  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> The documentation says the following is allowed:
> INSERT INTO sal_emp
>     VALUES ('Bill',
>     ARRAY[10000, 10000, 10000, 10000],
>     ARRAY[['meeting', 'lunch'], ['','']]);

> I cannot find justification for this in the standard.  According to my
> reading, it should be

> INSERT INTO sal_emp
>     VALUES ('Bill',
>     ARRAY[10000, 10000, 10000, 10000],
>     ARRAY[ARRAY['meeting', 'lunch'], ARRAY['','']]);

If it's an extension, it seems like a pretty reasonable one ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Assembler error
Next
From: Tom Lane
Date:
Subject: Re: Manual fixing of plpgsql_call_handler binary location -- good idea?