Boolean internal representation

Garo Hussenjian wrote:

Is there a way to always return booleans as 1/0 instead of t/f, without
using a CASE statement...

How do you feel about a plpgsql function that does it:

SELECT print01(boolcol) FROM ...

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

On Wed, Sep 18, 2002 at 08:33:04PM -0400, Bruce Momjian wrote:

Garo Hussenjian wrote:

Is there a way to always return booleans as 1/0 instead of t/f, without
using a CASE statement...

How do you feel about a plpgsql function that does it:

SELECT print01(boolcol) FROM ...

Interestinly, if you use Perl DBI, it translates t/f to 1/0 for you. Very
annoying if you're not expecting it to :)
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/