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
- boolstyle.diff (application/octet-stream) patch
---------- 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)