SQL-92 states that identifiers [for dictionary objects] are limited to 128 characters and are case-insensitive (unless delimited by double quotes), because they are automatically translated into uppercase by the system.
Standards are SQL-92, SQL-99 and SQL-2003, done by ISO and other standardization commitees.
It can be that JSP and ASP work different than standard SQL-92. I formyself prefer the easiest solution: just not use mixed case identifiers.
Best wishes,
Harald
On 9/25/06, Asaf Avraham <[EMAIL PROTECTED]> wrote:
Harald,This is the point, i need to use standard sql (from jsp, asp). and quote is not a standard
ThanksAsaf.
On 9/25/06, Harald Armin Massa <[EMAIL PROTECTED] > wrote:Asaf,
this is not a bug. To use identifier names (identfiers = column-names, table-names, view-names...) with capital and small characters, you need to doublequote those names.
So you can do select "Asaf" from "Avraham"
but not select Asaf from Avraham.
This behaviour is documented and intended.
Best wishes,
Harald
On 9/24/06, Asaf Avraham <[EMAIL PROTECTED] > wrote:
The following bug has been logged online:
Bug reference: 2648
Logged by: Asaf Avraham
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4.2
Operating system: win
Description: I can not create table name with capital and small
characters
Details:
I have table that contain name with capital and small characters (ex.
tblEmp). In the columns is the same (ex. EmpID).
In Creating table postgres add inverted commas on the name
When I'm running any query on this table i get:
1. select * from tblEmp
Get: ERROR: relation "tblemp" does not exist
2. select * from "tblEmp"
Get: Resulted
Thanks
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
-- Harald A. Massa, December 2005
http://groups.google.de/group/comp.lang.python/browse_thread/thread/285b9adeec188fb2
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
-- Harald A. Massa, December 2005
http://groups.google.de/group/comp.lang.python/browse_thread/thread/285b9adeec188fb2
