Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #2598: Columns named R are not accessible - although R is not a keyword
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Andreas Langegger <al(at)jku(dot)at>
- Cc: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: BUG #2598: Columns named R are not accessible - although R is not a keyword
- Date: Wed, 30 Aug 2006 12:37:56 -0400
Andreas Langegger <al(at)jku(dot)at> 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
- References:
- BUG #2598: Columns named R are not accessible - although R is not a keyword
- From: Andreas Langegger
- Re: BUG #2598: Columns named R are not accessible - although R is not a keyword
- From: Tom Lane
- Re: BUG #2598: Columns named R are not accessible - although
- From: Andreas Langegger
- BUG #2598: Columns named R are not accessible - although R is not a keyword
- Prev by Date: Re: BUG #2598: Columns named R are not accessible - although
- Next by Date: Re: BUG #2594: Gin Indexes cause server to crash on Windows
- Previous by thread: Re: BUG #2598: Columns named R are not accessible - although
- Next by thread: BUG #2599: AM/PM doesn't work in to_timestamp in the middle of a string
- Indexes: