Re: [HACKERS] PATCH: psql boolean display

2012-08-22 Thread Pavel Stehule
2012/8/21 Tom Lane : > "Kevin Grittner" writes: >> The type itself does output true/false; it's just psql that uses >> t/f. > > No, 't'/'f' is what boolout() returns. The 'true'/'false' results from > casting bool to text are intentionally different --- IIRC, Peter E. > argued successfully that t

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Phil Sorber
On Mon, Aug 20, 2012 at 7:19 PM, Tom Lane wrote: > "Kevin Grittner" writes: >> The type itself does output true/false; it's just psql that uses >> t/f. > > No, 't'/'f' is what boolout() returns. The 'true'/'false' results from > casting bool to text are intentionally different --- IIRC, Peter E.

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Tom Lane
"Kevin Grittner" writes: > The type itself does output true/false; it's just psql that uses > t/f. No, 't'/'f' is what boolout() returns. The 'true'/'false' results from casting bool to text are intentionally different --- IIRC, Peter E. argued successfully that this cast behavior is required by

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Tatsuo Ishii
> On Aug 20, 2012 6:28 PM, "Kevin Grittner" > wrote: >> >> Gurjeet Singh wrote: >> >> > On occasions I have wanted psql to emit the full 'True'/'False' >> > words instead of cryptic one-letter t/f, which can get lost on >> > long rows that get wrapped around on screen. Writing long-winded >> > CA

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Phil Sorber
On Aug 20, 2012 6:31 PM, "Thom Brown" wrote: > > On 20 August 2012 23:16, Phil Sorber wrote: > > > > On Aug 20, 2012 6:08 PM, "Thom Brown" wrote: > >> > >> On 20 August 2012 23:06, Phil Sorber wrote: > >> > > >> > On Aug 20, 2012 5:56 PM, "Thom Brown" wrote: > >> >> > >> >> On 20 August 2012 2

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Phil Sorber
On Aug 20, 2012 6:28 PM, "Kevin Grittner" wrote: > > Gurjeet Singh wrote: > > > On occasions I have wanted psql to emit the full 'True'/'False' > > words instead of cryptic one-letter t/f, which can get lost on > > long rows that get wrapped around on screen. Writing long-winded > > CASE expressi

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Thom Brown
On 20 August 2012 23:16, Phil Sorber wrote: > > On Aug 20, 2012 6:08 PM, "Thom Brown" wrote: >> >> On 20 August 2012 23:06, Phil Sorber wrote: >> > >> > On Aug 20, 2012 5:56 PM, "Thom Brown" wrote: >> >> >> >> On 20 August 2012 22:31, Phil Sorber wrote: >> >> > On Aug 20, 2012 5:19 PM, "Phil S

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Kevin Grittner
Gurjeet Singh wrote: > On occasions I have wanted psql to emit the full 'True'/'False' > words instead of cryptic one-letter t/f, which can get lost on > long rows that get wrapped around on screen. Writing long-winded > CASE expressions to get the effect is too much for small ad-hoc > queries.

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Phil Sorber
On Aug 20, 2012 6:08 PM, "Thom Brown" wrote: > > On 20 August 2012 23:06, Phil Sorber wrote: > > > > On Aug 20, 2012 5:56 PM, "Thom Brown" wrote: > >> > >> On 20 August 2012 22:31, Phil Sorber wrote: > >> > On Aug 20, 2012 5:19 PM, "Phil Sorber" wrote: > >> >> > >> >> On Aug 20, 2012 5:11 PM,

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Gurjeet Singh
On Mon, Aug 20, 2012 at 5:54 PM, Thom Brown wrote: > On 20 August 2012 22:10, Pavel Stehule wrote: > > 2012/8/20 Robert Haas : > >> On Sun, Aug 19, 2012 at 12:02 PM, Phil Sorber wrote: > >>> I am providing a patch to allow you to change the output of a boolean > >>> value in psql much like you

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Thom Brown
On 20 August 2012 23:06, Phil Sorber wrote: > > On Aug 20, 2012 5:56 PM, "Thom Brown" wrote: >> >> On 20 August 2012 22:31, Phil Sorber wrote: >> > On Aug 20, 2012 5:19 PM, "Phil Sorber" wrote: >> >> >> >> On Aug 20, 2012 5:11 PM, "Pavel Stehule" >> >> wrote: >> >> > >> >> > 2012/8/20 Robert H

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Phil Sorber
On Aug 20, 2012 5:56 PM, "Thom Brown" wrote: > > On 20 August 2012 22:31, Phil Sorber wrote: > > On Aug 20, 2012 5:19 PM, "Phil Sorber" wrote: > >> > >> On Aug 20, 2012 5:11 PM, "Pavel Stehule" wrote: > >> > > >> > 2012/8/20 Robert Haas : > >> > > On Sun, Aug 19, 2012 at 12:02 PM, Phil Sorber

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Pavel Stehule
2012/8/20 Thom Brown : > On 20 August 2012 22:10, Pavel Stehule wrote: >> 2012/8/20 Robert Haas : >>> On Sun, Aug 19, 2012 at 12:02 PM, Phil Sorber 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 request

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Thom Brown
On 20 August 2012 22:31, Phil Sorber wrote: > On Aug 20, 2012 5:19 PM, "Phil Sorber" wrote: >> >> On Aug 20, 2012 5:11 PM, "Pavel Stehule" wrote: >> > >> > 2012/8/20 Robert Haas : >> > > On Sun, Aug 19, 2012 at 12:02 PM, Phil Sorber wrote: >> > >> I am providing a patch to allow you to change t

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Thom Brown
On 20 August 2012 22:10, Pavel Stehule wrote: > 2012/8/20 Robert Haas : >> On Sun, Aug 19, 2012 at 12:02 PM, Phil Sorber 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 th

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Phil Sorber
On Aug 20, 2012 5:19 PM, "Phil Sorber" wrote: > > On Aug 20, 2012 5:11 PM, "Pavel Stehule" wrote: > > > > 2012/8/20 Robert Haas : > > > On Sun, Aug 19, 2012 at 12:02 PM, Phil Sorber wrote: > > >> I am providing a patch to allow you to change the output of a boolean > > >> value in psql much like

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Phil Sorber
On Aug 20, 2012 5:11 PM, "Pavel Stehule" wrote: > > 2012/8/20 Robert Haas : > > On Sun, Aug 19, 2012 at 12:02 PM, Phil Sorber 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 a

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Pavel Stehule
2012/8/20 Robert Haas : > On Sun, Aug 19, 2012 at 12:02 PM, Phil Sorber 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.

Re: [HACKERS] PATCH: psql boolean display

2012-08-20 Thread Robert Haas
On Sun, Aug 19, 2012 at 12:02 PM, Phil Sorber 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 updat