getting y/n or 1/0 from bool fields

From: Matthew Nuzum <ads(at)bearfruit(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: getting y/n or 1/0 from bool fields
Date: 2002-09-02 14:01:05
Message-ID: BaKc9.73038$Rx4.793180@twister.tampabay.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

Some of our development software is not really "PostgreSQL aware" in
that it expects bool values to be y/n (ala MS Access) or 1/0. However
it seems that Postgres returns t/f.

Does anyone know a way to get Postgres to return one of the above
(preferably, 1/0) for boolean values?

Ideally, it would be somewhat of a transparent feature, so that a
"SELECT * FROM table;" would have all bool values in the format above.

Any suggestions greatly apreciated,

Matthew Nuzum

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ericson Smith 2002-09-02 14:02:24 Re: php
Previous Message Warren Massengill 2002-09-02 13:58:07 php