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

On 7 January 2014 19:11, ChoonSoo Park <luispark(at)gmail(dot)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