Brian Hurt <bhurt@janestcapital.com> writes:
> SELECT true :: text;
> ERROR: cannot cast type boolean to text
> I was wondering why this is so.
Because there's no pg_cast entry for this conversion.
There will be one in 8.3, but for older releases make your own with
CREATE CAST.
regards, tom lane