Re: Column quoting in result set getters

On Wed, 2 Jun 2004, Manuel Sugawara wrote:

> When I try to get the value of a column by name, using quotes the
> driver throws an exception telling me that that column does not
> exists. The column name has accents:
>
> int val = res.getInt("\"última\"");
>
> Since quote_ident() quotes the names containing accents I think the
> driver should accept the quoted version as well or am I missing
> something? I'm using pg74.1jdbc3.jar.
>

I'm not sure what connection you are making between quote_ident and the
ResultSet methods, why should these act the same? It certainly is
possible to have column names with quotes, for example:

jurka=# create table quote ("""a""" int);
CREATE TABLE
jurka=# \d quote
Table "public.quote"
Column | Type | Modifiers
--------+---------+-----------
"a" | integer |

In this case ResultSet.getInt("\"a\"") would be correct, what are you
suggesting should be used in this case? ResultSet.getInt("\"\"\"a\"\"\"")

Kris Jurka