On Wed, 1 Sep 2004, sad wrote: > > There's a difference between an output function and a cast to text. > > One gives you an external representation of the data for end use. The > > other gives you an internal representation for manipulation. > > And at the same time > > 't'::TEXT can be casted to BOOL > 't'::BOOL > > but reverse.
select 't'::text::bool; ERROR: cannot cast type text to boolean If you're thinking 't'::bool, that's something different. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
