В Птн, 03/06/2005 в 15:07 +0200, Markus Bertheau ☭ пишет:
> В Птн, 03/06/2005 в 15:46 +0300, Achilleus Mantzios пишет:
>
> > Also according to the docs:
> > http://www.postgresql.org/docs/current/static/datatype-boolean.html
> >
> > "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."
>
> Ah, that works. Thanks very much.
Correcting myself, that doesn't work. It says something along the lines
of case expression must be of type boolean.
Markus
--
Markus Bertheau ☭ <twanger@bluetwanger.de>