Perhaps the 'create rule' is in the way, you could try something like:
CASE WHEN document_online THEN 1ELSE 0
END,
CASE WHEN document_valid 1ELSE 0
END
But if that doesnt work, I'm out of options aswel.
You could try the "instead query" separately to test whether the query
itself is correct.
Goodluck
> -----Oorspronkelijk bericht-----
> Van: Stephane Schildknecht [mailto:sschildknecht@aurora-linux.com]
> Verzonden: vrijdag 5 juli 2002 15:39
> Aan: Arjen van der Meijden
> CC: pgsql-sql@postgresql.org
> Onderwerp: Re: [SQL] Boolean to int
>
>
> 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 |
> |_________________________________________________________|
>
>
