Re: Bug in create type when missed the comma between element list

Diego <mrstephenamell@gmail.com>

From: Diego <mrstephenamell@gmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2024-11-04T16:28:29Z
Lists: pgsql-hackers
Thank you David!

That note: This slightly bizarre behavior is specified by SQL; 
PostgreSQL is following the standard.


On 11/4/24 13:19, David G. Johnston wrote:
> On Mon, Nov 4, 2024 at 9:17 AM Diego <mrstephenamell@gmail.com> wrote:
>
>
>     u: daf db: daf # CREATE TYPE test_enum AS ENUM(
>         'one'
>         'two',
>         'three',
>         'four'
>     );
>
>     maybe, some of you can help me to report it properly.
>
> That is working per SQL standard.  If you hadn't used newlines between 
> the elements you would have gotten an error; but the newlines between 
> literals is valid string literal syntax.
>
> https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS
>
> David J.
>