Skip to content

Case Statement in postgresql not supported #267

@erwin-frohsinn

Description

@erwin-frohsinn

Describe the bug
The following is not parsed. Seems that the "case" statement is not supported.

create table pole.t_spiel (
    id               varchar(10)               not null
        constraint t_spiel_pk
            primary key,
    v_id             varchar(10) generated always as (
        CASE
            WHEN ((id)::text ~ '^\d+$'::text) THEN (lpad((id)::text, 2, '0'::text))::character varying
            ELSE id
            END) stored
);

To Reproduce
Steps to reproduce the behavior:
Parse with simple_ddl_parser

Desktop (please complete the following information):

  • OS: Kubuntu
  • Python 3.12
  • Postgres

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions