Mailbox-Line: From sschildknecht@aurora-linux.com  Fri Jul  5 10:58:24 2002
Subject: Re: Boolean to int
From: Stephane Schildknecht <sschildknecht@aurora-linux.com>
To: Arjen van der Meijden <acm@tweakers.net>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <ag2esu$jmb$1@news.tudelft.nl>
References: <1025803595.20819.239.camel@fukse> <ag2esu$jmb$1@news.tudelft.nl>
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable
Date: 05 Jul 2002 15:38:43 +0200
Message-Id: <1025876323.10925.308.camel@fukse>
Mime-Version: 1.0

Le jeu 04/07/2002 =E0 23:32, Arjen van der Meijden a =E9crit :
> How about this hint in the postgresql-manual:
>=20
>    "Tip:  Values of the boolean type cannot be cast directly to other=20
> types (e.g., CAST (boolval AS integer) does not work). This can be=20
> accomplished using the CASE expression: CASE WHEN boolval THEN 'value if=
=20
> true' ELSE 'value if false' END. See also Section 4.12. "
>=20
> For more information:=20
> 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=20
			FROM document;

And, that doesn't work either...

psql:cnambo_proc_stock.sql:76: ERROR:  select rule's target list has too
many entries


>=20
--=20
 _St=E9phane SCHILDKNECHT___________________________________
| AurorA-SAS 69-71, Av. Pierre Grenier 92100 BOULOGNE     |
| Tel : 01.58.17.03.20 Fax : 01.58.17.03.21               |=20
| mailto:sschildknecht@aurora-linux.com - ICQ : 142504394 |
| "Free Markets have taught that innovation is best when  |=20
|  ideas flow freely." Adam Smith                         |
|_________________________________________________________|