Re: Insert Statement
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 6 Nov 2008 16:57:51 +0100
Message-ID: <491313ff$0$22726$426a74cc@news.free.fr>
Date: Thu, 6 Nov 2008 16:57:51 +0100
Message-ID: <491313ff$0$22726$426a74cc@news.free.fr>
<artmerar_at_gmail.com> a écrit dans le message de news: 4f5c6bdf-2ccd-49f5-b16e-65a51ba3f92d_at_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......
SQL does not know boolean datatype.
Regards
Michel
Received on Thu Nov 06 2008 - 09:57:51 CST