Re: 'true'::TEXT::BOOLEAN - Mailing list pgsql-sql

From Markus Bertheau ☭
Subject Re: 'true'::TEXT::BOOLEAN
Date
Msg-id 1117804023.9816.30.camel@dicaprio.akademie1.de
Whole thread Raw
In response to Re: 'true'::TEXT::BOOLEAN  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: 'true'::TEXT::BOOLEAN doesn't work  (Markus Bertheau ☭ <twanger@bluetwanger.de>)
List pgsql-sql
В Птн, 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.

Markus
-- 
Markus Bertheau ☭ <twanger@bluetwanger.de>



pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: 'true'::TEXT::BOOLEAN
Next
From: Markus Bertheau ☭
Date:
Subject: CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END