From: | "Colin Freas" <cef6(at)georgetown(dot)edu> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: JDBC bug? |
Date: | 2001-11-26 20:41:28 |
Message-ID: | IIEPJDIJEEBPKJGDFFBEAEDMCAAA.cef6@georgetown.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
> via quoted mixed case identifiers. I haven't seen any evidence that
> basic SQL operations (select, insert, update, delete) have a bug in them.
I'd peg a where clause as a basic SQL operation, and be it bug, feature,
annoyance, whatever, it wasn't functioning because of the case of a column
name.
This worked:
1. rs = stmt.executeQuery("select * from response");
But I wanted to do this, which didn't work:
2. rs = stmt.executeQuery("select * from response where questionID=16");
This is how I got it to work:
3. rs = stmt.executeQuery("SELECT \"response\".\"questionID\",
\"response\".\"respondentID\", \"response\".\"answer\", \"response\".\"ID\"
FROM \"response\" WHERE "\response\".\"questionID\"=16");
Sorry, does anyone think the third is better than the second?
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-11-26 20:42:27 | Re: JDBC bug? |
Previous Message | Barry Lind | 2001-11-26 20:34:43 | Re: JDBC bug? |