Στις 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
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных