From: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Camel case identifiers and folding |
Date: | 2019-03-16 21:46:41 |
Message-ID: | 20190316214641.bzyg7o5qv3bolvt4@hjp.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2019-03-16 14:00:34 -0600, Rob Sargent wrote:
> What sort of content is in your field of type text? Certainly, in
> English
> prose, “rob” is different than “Rob”
>
>
> I disagree. While the grammar for written English has rules when to
> write "rob" and when to write "Rob", that distinction usually carries no
> semantic difference. Consider:
[...]
> I don’t think it’s solely about the semantics. One might be contractually
> obligated to always spell a name in some exact way including it capitalization.
> For instance if referring to "Rob Sargent” as a quote or accreditation, then
> it’s not okay to let a typo “rob Sargent” go through.
1) Such contracts might exist, but they are only binding to the signing
parties, they don't affect what is commonly understood as "the English
language". Everybody else will see it as an obvious typo and won't
assume that this refers to some "rob Sargent" who is a different person
than "Rob Sargent".
2) I don't think the OP was talking about spell-checking. And in any
case spell-checking is more complicated than simply comparing strings
byte by byte.
hp
--
_ | Peter J. Holzer | we build much bigger, better disasters now
|_|_) | | because we have much more sophisticated
| | | hjp(at)hjp(dot)at | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2019-03-17 07:36:22 | How to parse XML in Postgres newer versions also |
Previous Message | Andrew Gierth | 2019-03-16 21:11:06 | Re: Camel case identifiers and folding |