Re: psql \set case sensitive for boolean (OFF/off) - Mailing list pgsql-patches

From Tom Lane
Subject Re: psql \set case sensitive for boolean (OFF/off)
Date
Msg-id 667.1095776694@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql \set case sensitive for boolean (OFF/off)  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-patches
Peter Eisentraut <peter_e@gmx.net> writes:
> Am Dienstag, 21. September 2004 13:01 schrieb Michael Paesold:
>> I would recommend to make this check at least case insensitive, because
>>
>> a) Since SQL is case insensitive, the current behaviour is not what you
>> would expect.

> In contrast, psql is case sensitive, so the current behavior is consistent.

True, but recognizing "off" case-insensitively seems like a painless
improvement.  What would it be likely to get wrong?  (I've forgotten
what the original backwards-compatibility issue alluded to in the
comment was all about, so maybe I'm missing something important.)

If anything I'd think we should migrate towards allowing all the same
alternatives that backend GUC accepts for booleans ...

            regards, tom lane

pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: psql \set case sensitive for boolean (OFF/off)
Next
From: Andrew Dunstan
Date:
Subject: pg_hba.conf additional comment re local line