From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Matthijs van der Vleuten <matthijs(at)zr40(dot)nl> |
Cc: | Brendan Jurd <direvus(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Marko Tiikkaja <marko(at)joh(dot)to>, Daniel Verite <daniel(at)manitou-mail(dot)org>, PostgreSQL hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: psql: add \pset true/false |
Date: | 2015-11-12 17:10:46 |
Message-ID: | CAFj8pRDbkWJMombDxf5G=hdQyvb2yJ7NhCwKbjOLX90n1SU0aw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2015-11-12 17:41 GMT+01:00 Matthijs van der Vleuten <matthijs(at)zr40(dot)nl>:
>
> On 12 Nov 2015, at 14:21, Brendan Jurd <direvus(at)gmail(dot)com> wrote:
>
> On Fri, 30 Oct 2015 at 00:51 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> The really key argument that hasn't been addressed here is why does such
>> a behavior belong in psql, rather than elsewhere? Surely legibility
>> problems aren't unique to psql users. Moreover, there are exactly
>> parallel facilities for other datatypes on the server side: think
>> DateStyle or bytea_output. So if you were trying to follow precedent
>> rather than invent a kluge, you'd have submitted a patch to create a GUC
>> that changes the output of boolout().
>>
>
> I find Tom's analogy to datestyle and bytea_output convincing.
>
> +1 for a GUC that changes the behaviour of boolout.
>
>
> -1 for changing boolout(). It will break anything that receives boolean
> values from the server. How a client is going to display values (of any
> type) is logic that should belong in the client, not in the protocol.
>
This is not fully valid, because transformation from binary to text is
processed on server side. And client side transformation is easy only for
scalar values.
Regards
Pavel
From | Date | Subject | |
---|---|---|---|
Next Message | Fabien COELHO | 2015-11-12 18:09:57 | Re: checkpointer continuous flushing |
Previous Message | Andres Freund | 2015-11-12 17:05:40 | Re: checkpointer continuous flushing |