Re: Casing

2001-11-27 Thread Colin Freas
Dave page wrote: > I have to admit I'm confused by your problem. Dang. I am too. I swear I ran a test case where I ran this as arbitrary SQL: create table Test (Test text); And it presented in the definition pane as: CREATE TABLE "Test" ( "Test" text ); I even ran a servlet querying the ta

Re: Casing

2001-11-27 Thread Dave Page
It's rumoured that Colin Freas once said: > > For anyone who follows the JDBC mailing list, there was a discussion > over the last day or so about the casing of identifiers in Postgres and > SQL92. > > I failed to realize that when a table is created with quotations aroun

Casing

2001-11-27 Thread Colin Freas
For anyone who follows the JDBC mailing list, there was a discussion over the last day or so about the casing of identifiers in Postgres and SQL92. I failed to realize that when a table is created with quotations around the identifiers and the case is mixed, you must then refer to that