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.

Tue, 09 Oct 2001 13:37:06 -0700
Dave Blasby <dblasby@refractions.net>
text(bool) not defined
Dave Blasby writes:

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

case when value then 'answer if true' else 'answer if false' end

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


Wed, 10 Oct 2001 00:35:11 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: text(bool) not defined