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

Reply via email to