Home > mailing lists

Re: text(bool) not defined - Mailing list pgsql-hackers

From	Peter Eisentraut
Subject	Re: text(bool) not defined
Date	October 9, 2001 21:29:44
Msg-id	Pine.LNX.4.30.0110100034440.672-100000@peter.localdomain Whole thread Raw
In response to	text(bool) not defined (Dave Blasby <dblasby@refractions.net>)
List	pgsql-hackers

Tree view

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

pgsql-hackers by date:

From: Dave Blasby
Date: 09 October 2001, 19:37:45
Subject: text(bool) not defined

From: Peter Eisentraut
Date: 09 October 2001, 21:29:46
Subject: EXTRACT broken

Re: text(bool) not defined - Mailing list pgsql-hackers

Previous

Next