getting y/n or 1/0 from bool fields - Mailing list pgsql-general

From Matthew Nuzum
Subject getting y/n or 1/0 from bool fields
Date
Msg-id BaKc9.73038$Rx4.793180@twister.tampabay.rr.com
Whole thread Raw
Responses Re: getting y/n or 1/0 from bool fields
Re: getting y/n or 1/0 from bool fields
List 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


pgsql-general by date:

Previous
From: "Amit Gupta"
Date:
Subject: Fw: recreate_mmaps_after_fork_failed
Next
From: "Dorward Villaruz"
Date:
Subject: help please