Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group