Re: 'true'::TEXT::BOOLEAN doesn't work

From: Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: Michael Glaesemann <grzm(at)myrealbox(dot)com>, PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: 'true'::TEXT::BOOLEAN doesn't work
Date: 2005-06-03 13:43:59
Message-ID: 1117806239.9816.39.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

В Птн, 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(at)bluetwanger(dot)de>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-06-03 13:47:11 Re: 'true'::TEXT::BOOLEAN
Previous Message Markus Bertheau ☭ 2005-06-03 13:17:26 CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END