Re: Is there a way to return "true"/"false" string for boolean type?

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: Is there a way to return "true"/"false" string for boolean type?
Дата
Msg-id CAFjNrYvHprYtr8epAtpGfkN26n6O5d6SLd+XOM-jECyXAeCNew@mail.gmail.com
обсуждение исходный текст
Ответ на Is there a way to return "true"/"false" string for boolean type?  (ChoonSoo Park <luispark@gmail.com>)
Ответы Re: Is there a way to return "true"/"false" string for boolean type?
Список pgsql-general
Дерево обсуждения
On 7 January 2014 19:11, ChoonSoo Park <luispark@gmail.com> wrote:
Hello Gurus,

I have several tables with lots of boolean columns.
When I run select query for the tables, I always get 't' or 'f' for boolean types.

Is there a way to return 'true' or 'false' string for boolean type except using CASE WHEN ... clause?
I mean global postgres configuration setting to return 'true'/'false' instead of t/f.

Thank you,
Choon Park

Hi,
if you cast the boolean values to text, then you should get 'true'/'false':

SELECT true::boolean::text, false::boolean::text;
 text | text  
------+-------
 true | false
(1 row)

Does it solve your problem? Why do you want to have true/false instead of t/f?

regards,
Szymon

В списке pgsql-general по дате отправления:

Предыдущее
От: ChoonSoo Park
Дата:
Сообщение: Is there a way to return "true"/"false" string for boolean type?
Следующее
От: ChoonSoo Park
Дата:
Сообщение: Re: Is there a way to return "true"/"false" string for boolean type?