On Tue, Jan 7, 2014 at 10:11 AM, ChoonSoo Park <luisp...@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. > Question for others.. hstore(record) doesn't seem to cast the rows to text using the normal text cast, right? Why is that? If I have a table with a boolean column and I call hstore(table), I see 't', not 'true'. But true::text is 'true' and false::text is 'false'.
