Re: 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?
Дата
Msg-id CACgbiFu1jRZJN-14kqL3p9E9F5JJf=hHKsb8qniG1ZzB0FVMbw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Is there a way to return "true"/"false" string for boolean type?  (Szymon Guz <mabewlun@gmail.com>)
Ответы Re: Is there a way to return "true"/"false" string for boolean type?
Список pgsql-general
Дерево обсуждения
On Tue, Jan 7, 2014 at 1:29 PM, Szymon Guz <mabewlun@gmail.com> wrote:
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

In the custom stored function, I'm returning a resultset using hstore function.
RETURN QUERY SELECT a few other columns, hstore(t.*) FROM table t WHERE condition.

I don't want to change it to 

SELECT a few other columns, hstore('c1', CAST(t.c1 AS TEXT)) || hstore('c2', CAST(t.c2 AS TEXT)) || ...hstore('cn', t.cn::text) || ... FROM table t WHERE condition.

Thanks,
Choon Park

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