Hi everybody,
Many thanks for all your comments.
It appears that clarity is very important in a user manual. I like both
Chris and Tom 's expression.
Chris :
*"Unless double-quoted, all identifiers are folded to lower case,
making comparisons generally case insensitive. The SQL standard
mandate
Tom Lane wrote:
> Alvaro Herrera writes:
> > Bruce Momjian escribi?:
> >> I found one place in the docs where this wasn't immediately clear, so I
> >> applied the attached documentation patch.
>
> > I liked Tom's suggestion better, because then you don't start
> > questioning about quoting key wo
Alvaro Herrera writes:
> Bruce Momjian escribió:
>> I found one place in the docs where this wasn't immediately clear, so I
>> applied the attached documentation patch.
> I liked Tom's suggestion better, because then you don't start
> questioning about quoting key words or not.
Yes, exactly, tha
Bruce Momjian escribió:
> I found one place in the docs where this wasn't immediately clear, so I
> applied the attached documentation patch.
I liked Tom's suggestion better, because then you don't start
questioning about quoting key words or not.
> --- 144,150
>case sensitivity
>
Robert Haas wrote:
> On Wed, Feb 3, 2010 at 2:36 PM, Chris Travers wrote:
> > I don't like the proposed wording though. ?I would suggest something more
> > like:
>
> Just to be clear, that's the actual wording, not a proposal.
I found one place in the docs where this wasn't immediately clear, s
On Wed, Feb 3, 2010 at 2:36 PM, Chris Travers wrote:
> I don't like the proposed wording though. I would suggest something more
> like:
Just to be clear, that's the actual wording, not a proposal.
...Robert
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to yo
Tom Lane wrote:
> "Key words and unquoted identifiers are case insensitive..."
FWIW, that is the *exact* rewording that came to mind for me as a
possible solution.
-Kevin
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgr
Chris Travers wrote:
> It is probably understandable that some people
> would miss it (I did, a moment ago, until you mentioned it).
That seems like pretty good evidence that a footnote or
qualification of the initial statement would occasionally save some
confusion.
-Kevin
--
Sent via pgs
Chris Travers writes:
> On Wed, Feb 3, 2010 at 11:37 AM, Tom Lane wrote:
>> Kelly SACAULT writes:
>>> ".. Identifier and key word names are case insensitive..."
>>
>> You need to not stop reading at that point, but continue on to the part
>> that explains how quoted identifiers work.
> The onl
On Wed, Feb 3, 2010 at 11:37 AM, Tom Lane wrote:
> Kelly SACAULT writes:
>> Here is what I read from the officiel manual :
>> http://www.postgresql.org/docs/8.0/static/sql-syntax.html
>> stating that :
>> ".. Identifier and key word names are case insensitive..."
>
> You need to not stop reading
On Wed, Feb 3, 2010 at 11:30 AM, Robert Haas wrote:
> Quoting an identifier also makes it case-sensitive, whereas unquoted
> names are always folded to lower case. For example, the identifiers
> FOO, foo, and "foo" are considered the same by PostgreSQL, but "Foo"
> and "FOO" are different from th
Kelly SACAULT writes:
> Here is what I read from the officiel manual :
> http://www.postgresql.org/docs/8.0/static/sql-syntax.html
> stating that :
> ".. Identifier and key word names are case insensitive..."
You need to not stop reading at that point, but continue on to the part
that explains ho
On Wed, Feb 3, 2010 at 2:13 PM, Kelly SACAULT wrote:
> Here is what I read from the officiel manual :
> http://www.postgresql.org/docs/8.0/static/sql-syntax.html
>
> stating that :
> ".. Identifier and key word names are case insensitive..."
>
> This is not the truth at all and I think that this s
Hi Pavel, and Chris,
Thank you both your yours responses.
Here is what I read from the officiel manual :
http://www.postgresql.org/docs/8.0/static/sql-syntax.html
stating that :
".. Identifier and key word names are case insensitive..."
This is not the truth at all and I think that this stateme
Hello,
usually sql identifiers are case insensitive. There are exception. If
you use double quotes for sql identifier, then you have to write exact
same identifier everywhere.
postgres=# create table Foo(a integer);
CREATE TABLE
Time: 174,078 ms
postgres=# select * from Foo;
a
---
(0 rows)
Time
On Tue, Feb 2, 2010 at 12:11 PM, Kelly SACAULT wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5308
> Logged by: Kelly SACAULT
> Email address: kelly.saca...@gmail.com
> PostgreSQL version: 8.4.2
> Operating system: Ubuntu 9.10
> Description: How
The following bug has been logged online:
Bug reference: 5308
Logged by: Kelly SACAULT
Email address: kelly.saca...@gmail.com
PostgreSQL version: 8.4.2
Operating system: Ubuntu 9.10
Description:How to disable Case sensitivity on naming identifiers
Details:
I have in
17 matches
Mail list logo
