[SQL] CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END

Hi, is it planned to support the following insert syntax? INSERT INTO table VALUES (CASE WHEN arg_whatever IS NULL THEN DEFAULT ELSE arg_whatever END); I have the DEFAULT inside the CASE expression in mind. Markus -- Markus Bertheau ☭ <[EMAIL PROTECTED]> ---(end of br

Re: [SQL] CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END

Markus Bertheau =?UTF-8?Q?=E2=98=AD?= <[EMAIL PROTECTED]> writes: > is it planned to support the following insert syntax? > INSERT INTO table VALUES (CASE WHEN arg_whatever IS NULL THEN DEFAULT > ELSE arg_whatever END); No. AFAICS, SQL99 only defines DEFAULT as the direct INSERT or UPDATE target