Andreas Langegger <[EMAIL PROTECTED]> writes: > Well, I also tried your simple regression test and it worked. The more > I'm wondering why this does not:
> CREATE TABLE sunspots > ... > "R" int2, "R" with double quotes represents capital R, but when you write R without quotes in a query, it's implicitly downcased. See http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS If you spell it like that in the table definition then you'll need to use quotes every time you refer to the column, too. regards, tom lane ---------------------------(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
