Switching from MySQL to PostgreSQL, JDBC drivers behaving differently

Поиск
Список
Период
Сортировка
От Matthias Karlsson
Тема Switching from MySQL to PostgreSQL, JDBC drivers behaving differently
Дата
Msg-id 20070304141231.351EE14D8C7@smtp-2.sys.kth.se
обсуждение исходный текст
Ответы Re: Switching from MySQL to PostgreSQL, JDBC drivers behaving differently  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
Hi,

I originally had a much longer mail written describing in detail why I had a
problem with my current framework, but I decided to go with a simple
question instead :)

If I submit the following query to PostgreSQL:

select a.*, b.* from A a
inner join B b on b.id = a.b_id

where (for instance) both A and B have a column named 'name', is it possible
to distinguish between the two without using explicit positioning with the
JDBC interface? That is, with the MySQL driver, I can write:

rs.getString("a.name") and rs.getString("b.name"), but this doesn't seem to
work with PostgreSQL.

Sincerely,
Matthias Karlsson


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Alex Malone
Дата:
Сообщение: Re: TimestampUtils.toString() speedup
Следующее
От: peter royal
Дата:
Сообщение: Re: statement caching proof of concept redux