getting y/n or 1/0 from bool fields

Поиск
Список
Период
Сортировка
От Matthew Nuzum
Тема getting y/n or 1/0 from bool fields
Дата
Msg-id BaKc9.73038$Rx4.793180@twister.tampabay.rr.com
обсуждение исходный текст
Ответы Re: getting y/n or 1/0 from bool fields  (tony <tony@animaproductions.com>)
Re: getting y/n or 1/0 from bool fields  (Gregory Seidman <gss+pg@cs.brown.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Amit Gupta"
Дата:
Сообщение: Fw: recreate_mmaps_after_fork_failed
Следующее
От: "Dorward Villaruz"
Дата:
Сообщение: help please