CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END

From: Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END
Date: 2005-06-03 13:17:26
Message-ID: 1117804646.9816.37.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)bluetwanger(dot)de>

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Bertheau ☭ 2005-06-03 13:43:59 Re: 'true'::TEXT::BOOLEAN doesn't work
Previous Message Markus Bertheau ☭ 2005-06-03 13:07:03 Re: 'true'::TEXT::BOOLEAN