Re: cannot cast type boolean to text?

Поиск
Список
Период
Сортировка
От Shoaib Mir
Тема Re: cannot cast type boolean to text?
Дата
Msg-id bf54be870706141141k58fd91f2hd01bde4addfd5516@mail.gmail.com
обсуждение исходный текст
Ответ на cannot cast type boolean to text?  (Brian Hurt <bhurt@janestcapital.com>)
Список pgsql-novice
You can do this by creating a custom cast for it.

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 6/14/07, Brian Hurt <bhurt@janestcapital.com> wrote:
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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: cannot cast type boolean to text?
Следующее
От: "Shoaib Mir"
Дата:
Сообщение: Re: cannot cast type boolean to text?