Postgres Pro
Downloads
Home   >   mailing lists

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

From Markus Bertheau ☭
Subject CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END
Date
Msg-id 1117804646.9816.37.camel@dicaprio.akademie1.de
Whole thread Raw
Responses Re: CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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 ☭ <twanger@bluetwanger.de>

pgsql-sql by date:

Previous
From: Markus Bertheau ☭
Date:
Subject: Re: 'true'::TEXT::BOOLEAN
Next
From: Markus Bertheau ☭
Date:
Subject: Re: 'true'::TEXT::BOOLEAN doesn't work