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; -- 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