text(bool) not defined

From: Dave Blasby <dblasby(at)refractions(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: text(bool) not defined
Date: 2001-10-09 20:37:06
Message-ID: 3BC35FF2.94696C5F@refractions.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I've noticed that text(bool) isnt a defined function (nor does
'true'::bool::text work).

It would be great to have this defined.

Since "select 'false'::bool" gives 'f' and "select 'true'::bool" gives
't', perhaps text(bool) should return 't' or 'f'.

A case can, also, be given for returning 'true' or 'false'.

dave
ps. 7.1.2 on solaris
pps. "select boolin(true)" causes the backend to core.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-10-09 22:35:11 Re: text(bool) not defined
Previous Message Oleg Bartunov 2001-10-09 18:06:45 Re: Problem with cyrilic