2012/8/20 Robert Haas <robertmh...@gmail.com>: > On Sun, Aug 19, 2012 at 12:02 PM, Phil Sorber <p...@omniti.com> wrote: >> I am providing a patch to allow you to change the output of a boolean >> value in psql much like you can do with NULL. A client requested this >> feature and we thought it may appeal to someone else in the community. >> >> The patch includes updated docs and a regression test. The code >> changes themselves are pretty simple and straightforward. >> >> Example from the regression test: >> >> SELECT true, false; >> bool | bool >> ------+------ >> t | f >> (1 row) >> >> \pset booltrue 'foo' >> \pset boolfalse 'bar' >> SELECT true, false; >> bool | bool >> ------+------ >> foo | bar >> (1 row) >> >> \pset booltrue 't' >> \pset boolfalse 'f' >> SELECT true, false; >> bool | bool >> ------+------ >> t | f >> (1 row) >> >> As always, comments welcome. > > Why not just do it in the SQL? > > SELECT CASE WHEN whatever THEN 'foo' ELSE 'bar' END AS whatever;
I understand this motivation - although I was more happy with server side solution. Regards Pavel Stehule > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
