Re: Boolean to int - Mailing list pgsql-sql

From Stephane Schildknecht
Subject Re: Boolean to int
Date
Msg-id 1025876323.10925.308.camel@fukse
Whole thread Raw
In response to Re: Boolean to int  (Arjen van der Meijden <acm@tweakers.net>)
Responses Re: Boolean to int
List pgsql-sql
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                         |
|_________________________________________________________|





pgsql-sql by date:

Previous
From: Mark Frazer
Date:
Subject: Re: Possible Bug regarding temp tables (sql or psql?)
Next
From: Stephan Szabo
Date:
Subject: Re: How do i return a dataset from a stored procedure