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
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
On Wed, Feb 3, 2010 at 2:13 PM, Kelly SACAULT kelly.saca...@gmail.com 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
On Wed, Feb 3, 2010 at 11:30 AM, Robert Haas robertmh...@gmail.com 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
Kelly SACAULT kelly.saca...@gmail.com 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
On Wed, Feb 3, 2010 at 11:37 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Kelly SACAULT kelly.saca...@gmail.com 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...
Chris Travers ch...@metatrontech.com writes:
On Wed, Feb 3, 2010 at 11:37 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Kelly SACAULT kelly.saca...@gmail.com writes:
.. Identifier and key word names are case insensitive...
You need to not stop reading at that point, but continue on to the part
Chris Travers ch...@metatrontech.com 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.
Tom Lane t...@sss.pgh.pa.us 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:
Robert Haas wrote:
On Wed, Feb 3, 2010 at 2:36 PM, Chris Travers ch...@metatrontech.com 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
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
primarycase
Alvaro Herrera alvhe...@commandprompt.com 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
Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com 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
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
On Tue, Feb 2, 2010 at 12:11 PM, Kelly SACAULT kelly.saca...@gmail.com 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
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)
16 matches
Mail list logo
