Re: Camel case identifiers and folding

2019-03-16 Thread Peter J. Holzer
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 t

Re: Camel case identifiers and folding

2019-03-16 Thread Andrew Gierth
> "Morris" == Morris de Oryx writes: Morris> UUIDs as a type are an interesting case in Postgres. They're Morris> stored as a large numeric for efficiency (good!), but are Morris> presented by default in the 36-byte format with the dashes. Morris> However, you can also search using the da

Re: Camel case identifiers and folding

2019-03-16 Thread Rob Sargent
>> 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

Re: Camel case identifiers and folding

2019-03-16 Thread Peter J. Holzer
On 2019-03-15 17:09:49 -0600, Rob Sargent wrote: > On Mar 15, 2019, at 4:43 PM, Morris de Oryx > wrote: > > The original question has already been answered really well, but it > reminds > me to mention that Postgres text/varchar values are case-sensitive. Here's > a list of the

Re: Fwd: Camel case identifiers and folding

2019-03-16 Thread Tom Lane
Steve Haresnape writes: > As I said, I don't want to quote my identifiers. I know what that does. I > want to specify them in a certain way, see them in that same way, but refer > to them in any old way. > You can call it normalize or fold or whatever. It's a bad design choice, > and not even a co

Re: Fwd: Camel case identifiers and folding

2019-03-16 Thread Adrian Klaver
On 3/16/19 1:53 AM, Steve Haresnape wrote: My apologies I sent this reply to David only by mistake. -- Forwarded message - From: *Steve Haresnape* > Date: Fri, 15 Mar 2019 at 13:09 Subject: Re: Camel case identifiers and folding To: Da

Fwd: Camel case identifiers and folding

2019-03-16 Thread Steve Haresnape
My apologies I sent this reply to David only by mistake. -- Forwarded message - From: Steve Haresnape Date: Fri, 15 Mar 2019 at 13:09 Subject: Re: Camel case identifiers and folding To: David G. Johnston As I said, I don't want to quote my identifiers. I know what that does. I