From: Stephane Schildknecht <sschildknecht@aurora-linux.com>
To: Arjen van der Meijden <acm@tweakers.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Boolean to int
Date: 05 Jul 2002 15:38:43 +0200
Message-ID: <1025876323.10925.308.camel@fukse> (raw)
In-Reply-To: <ag2esu$jmb$1@news.tudelft.nl>
References: <1025803595.20819.239.camel@fukse>
<ag2esu$jmb$1@news.tudelft.nl>
Le jeu 04/07/2002 à 23:32, Arjen van der Meijden a écrit :
> How about this hint in the postgresql-manual:
>
> "Tip: Values of the boolean type cannot be cast directly to other
> types (e.g., CAST (boolval AS integer) does not work). This can be
> accomplished using the CASE expression: CASE WHEN boolval THEN 'value if
> true' ELSE 'value if false' END. See also Section 4.12. "
>
> For more information:
> http://www.postgresql.org/idocs/index.php?datatype-boolean.html
> and
> http://www.postgresql.org/idocs/index.php?functions-conditional.html
I tried that :
CREATE RULE boolean_return AS ON SELECT TO DOCUMENT DO INSTEAD
SELECT
document_id,
workflow_id,
type_document_id,
image_id,
theme_id,
document_version,
document_surtitre,
document_titre,
document_chapeau,
document_synthese,
document_corps,
document_pdf,
document_date_creation,
document_mot_clef,
document_online,
document_valid,
CASE document_online WHEN TRUE THEN 1
WHEN FALSE THEN 0
END,
CASE document_valid WHEN TRUE THEN 1
WHEN FALSE THEN 0
END
FROM document;
And, that doesn't work either...
psql:cnambo_proc_stock.sql:76: ERROR: select rule's target list has too
many entries
>
--
_Stéphane SCHILDKNECHT___________________________________
| AurorA-SAS 69-71, Av. Pierre Grenier 92100 BOULOGNE |
| Tel : 01.58.17.03.20 Fax : 01.58.17.03.21 |
| mailto:sschildknecht@aurora-linux.com - ICQ : 142504394 |
| "Free Markets have taught that innovation is best when |
| ideas flow freely." Adam Smith |
|_________________________________________________________|
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sschildknecht@aurora-linux.com, acm@tweakers.net
Subject: Re: Boolean to int
In-Reply-To: <1025876323.10925.308.camel@fukse>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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