cannot cast type boolean to text?

From: Brian Hurt <bhurt(at)janestcapital(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: cannot cast type boolean to text?
Date: 2007-06-14 18:30:44
Message-ID: 46718954.60903@janestcapital.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm not sure if this is the right
So when I do:
SELECT true :: text;
in psql, I get back:

ERROR: cannot cast type boolean to text

I was wondering why this is so. Unfortunately, the place where I hit
the problem was in a function that takes arguments of type ANYELEMENT
and wants to convert them to text. Which doesn't make it impossible to
work around this, just more annoying.

This is Postgres 8.1.4.

Would this be something worthwhile to post to Hackers?

Brian

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2007-06-14 18:38:45 Re: cannot cast type boolean to text?
Previous Message Richard Broersma Jr. 2007-06-14 05:22:44 Re: no results for nextval() query?