Insert Statement
From: <artmerar_at_gmail.com>
Date: Thu, 6 Nov 2008 07:41:32 -0800 (PST)
Message-ID: <4f5c6bdf-2ccd-49f5-b16e-65a51ba3f92d@n1g2000prb.googlegroups.com>
Date: Thu, 6 Nov 2008 07:41:32 -0800 (PST)
Message-ID: <4f5c6bdf-2ccd-49f5-b16e-65a51ba3f92d@n1g2000prb.googlegroups.com>
Can you use a CASE statement in an INSERT clause with Boolean expressions? Something like
DECLARE
b boolean := TRUE;
BEGIN
INSERT INTO a
VALUES (
CASE
WHEN b = TRUE THEN 'AB'
WHEN b = FALSE THEN 'CD'
END);
END;
/
I've tried several syntax variations with no luck...... Received on Thu Nov 06 2008 - 09:41:32 CST