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...... ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend