Fwd: PATCH: psql boolean display

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2012-09-02T05:13:19Z
Lists: pgsql-hackers

Attachments

---------- Forwarded message ----------
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: 2012/9/1
Subject: PATCH: psql boolean display
To: Phil Sorber <phil@omniti.com>


Hello

I am looking to your patch:

I have only one note. I don't think so using any text for values
"true" and "false" is good idea. I don't see a sense of any special
texts like "foo", "bar" from your example.

More strict design is better - I wrote simple modification - it is
based on psql psets - and it add new configuration settings "boolstyle
[char|word]". A advantage of this design is consistency  and possible
autocomplete support.

Regards

Pavel



postgres=> select true, false;
 bool │ bool
──────┼──────
 t    │ f
(1 row)

postgres=> \pset boolstyle word
Bool output style is word.
postgres=> select true, false;
 bool │ bool
──────┼───────
 true │ false
(1 row)