Re: getting y/n or 1/0 from bool fields

On Mon, 2002-09-02 at 16:01, Matthew Nuzum wrote:

> 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,

My JSP applications don't care. The column is y/n type and y = t and n =
f. Where the conversion takes place I do not know?

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html