Re: cast bool/int

Στις Monday 23 March 2009 09:59:12 ο/η Zdravko Balorda έγραψε:
>

> Hi,
> I need a casting operator from boolean to integer,
> tu put in ALTER TABLE statment after USING.
>

Sorry in the above email i meant smth like
CASE WHEN column='t' THEN 1 ELSE 0 END

however
SELECT 't'::boolean::int;
int4
------
   1
(1 row)

and
SELECT 'f'::boolean::int;
 int4
------
   0
(1 row)

work in 8.3

> Any ideas? Thanks.
>
> Zdravko
>
>



--
Achilleas Mantzios

--

Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql