Re: [GENERAL] Case statement with different data types

2009-10-14 Thread Pavel Stehule
Hello try to explicit cast select 't'::boolean; regards Pavel Stehule 2009/10/14 Gus Waddell : > 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:  avai

[GENERAL] Case statement with different data types

2009-10-14 Thread Gus Waddell
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 lik