CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END

pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed

CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END
2+ messages / 2 participants
[nested] [flat]

* CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END
@ 2005-06-03 13:17 Markus Bertheau ☭ <twanger@bluetwanger.de>
  2005-06-03 14:16 ` Re: CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Markus Bertheau ☭ @ 2005-06-03 13:17 UTC (permalink / raw)
  To: 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@bluetwanger.de>




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END
  2005-06-03 13:17 CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END Markus Bertheau ☭ <twanger@bluetwanger.de>
@ 2005-06-03 14:16 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-06-03 14:16 UTC (permalink / raw)
  To: Markus Bertheau ☭ <twanger@bluetwanger.de>; +Cc: pgsql-sql

Markus Bertheau =?UTF-8?Q?=E2=98=AD?= <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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2005-06-03 14:16 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-03 13:17 CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END Markus Bertheau ☭ <twanger@bluetwanger.de>
2005-06-03 14:16 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox