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. >