This: SELECT true::integer, false::integer
also works on 8.1 -- regards mk 2009/3/23 Achilleas Mantzios <ach...@matrix.gatewaynet.com> > Στις 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 >