Postgres Pro
Downloads
Home   >   mailing lists

Re: CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END - Mailing list pgsql-sql

From Tom Lane
Subject Re: CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END
Date
Msg-id 4626.1117808194@sss.pgh.pa.us
Whole thread Raw
In response to CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END  (Markus Bertheau ☭ <twanger@bluetwanger.de>)
List pgsql-sql
Tree view 
Markus Bertheau ☭ <twanger@bluetwanger.de> 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 expression.
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: 'true'::TEXT::BOOLEAN
Next
From: Ami Ganguli
Date:
Subject: using a selected row as a function parameter