Обсуждение: Boolean internal representation
Is there a way to always return booleans as 1/0 instead of t/f, without using a CASE statement... Thanks and Regards, Garo. =-=-==-=-=-== Xapnet Internet Solutions 1501 Powell St., Suite N Emeryville, CA 94608 Tel - (510) 655-9771 Fax - (510) 655-9775 Web - http://www.xapnet.com
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/ > There are 10 kinds of people in the world, those that can do binary > arithmetic and those that can't.