Comma-separated predicates in simple CASE expressions (f263)

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Comma-separated predicates in simple CASE expressions (f263)
Date: 2022-08-30 22:12:26
Message-ID: 67830AE2-BF0D-4A85-8DBC-A90F804A7DAA@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I was looking at F263 from the SQL standard, Comma-separated predicates in
simple CASE expression, and thinking if we could support this within the
framework we already have at a minimal added cost. The attached sketch diff
turns each predicate in the list into a CaseWhen node and uses the location
from parsing for grouping in errorhandling for searched case.

Is this a viable approach or am I missing something obvious?

--
Daniel Gustafsson https://vmware.com/

Attachment Content-Type Size
f263_case_list.diff application/octet-stream 4.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-08-30 22:20:37 Re: Comma-separated predicates in simple CASE expressions (f263)
Previous Message Nathan Bossart 2022-08-30 22:10:26 Re: replacing role-level NOINHERIT with a grant-level option