Fwd: PATCH: psql boolean display - Mailing list pgsql-hackers

From Pavel Stehule
Subject Fwd: PATCH: psql boolean display
Date
Msg-id CAFj8pRBvgKCuVXwXg=ry=hSQ7Q7KgWMQ-foV1A1V2zycv2eozQ@mail.gmail.com
Whole thread Raw
Responses Re: Fwd: PATCH: psql boolean display
List pgsql-hackers
---------- 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)

Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Yet another failure mode in pg_upgrade
Next
From: Sergey Koposov
Date:
Subject: bitmap scan much slower than index scan, hash_search_with_hash_value