On Tuesday 31 August 2004 16:22, Geoffrey wrote: > sad wrote: > > you wrote: > >>you can use CREATE CAST to make your own cast from boolean to text. > > > > thnx it helps. > > > > and i am still desire to know _WHY_ there are no predefined cast for BOOL > > ? and at the same time there are predefined casts for INT and FLOAT...... > > I'd like to understand in what context you would find this useful. > Don't take me wrong please. I'm by no means a db expert, but I can't > see a purpose for such a cast. Can you provide a reasonable example of > such usage?
Yes i can. look: CREATE TABLE t (a int, b text, c bool); SELECT 'the row is: a='||a::TEXT||' b='||b||' c='||c::TEXT FROM t; ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings