Hello try to explicit cast select 't'::boolean; regards Pavel Stehule 2009/10/14 Gus Waddell <angus.waddell@xxxxxxxxxxxxxx>: > Hi everyone, > > I am currently working on an app that is split into several databases with > the same table but a column with differing data type. > > eg. Database 1 > tablename: gp > column: available - data type boolean > > Database 2 > tablename: gp > column: available - data type character(1) > > I would like to be able to create a query that returns 'T' or 'F' using the > same code & query. > > I have tried a few different cast() options without success - and then > tried: > > SELECT > CASE > WHEN ((SELECT data_type FROM information_schema.columns WHERE > table_name = 'gp' and column_name = 'available') = 'boolean') THEN > CASE > WHEN (available) THEN 'T' > ELSE 'F' > END > ELSE > CASE > WHEN (available='T' OR available='t') then 'T' > ELSE 'F' > END > END as available > FROM > gp > > > When I run this query on the boolean data type database it works correctly - > however on the character field I get the error 'ERROR: argument of > CASE/WHEN must be type boolean, not type character' > > I really don't want to go through and change data types just at the moment - > can anyone advise any way around this? > > Many thanks, > Gus > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
