On Fri, Jun 03, 2005 at 14:23:37 +0200, Markus Bertheau ??? <[EMAIL PROTECTED]> wrote: > This also bypasses the built in postgresql boolean literal parsing. > > I think casting from text to boolean should be possible, and use the > same algorithm that's used when casting from "unknown" to boolean.
You probably want boolin. area=> select boolin('0'), boolin('f'), boolin('false'); boolin | boolin | boolin --------+--------+-------- f | f | f (1 row) Note that the function will error out if the argument is garbage. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings