From: Barry Lind <barry@xythos.com>
To: Arsalan Zaidi <azaidi@directi.com>
Cc: PostgreSQL jdbc list <pgsql-jdbc@postgresql.org>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Subject: Re: [INTERFACES] New code for JDBC driver
Date: Mon, 02 Jul 2001 09:21:35 -0700
Message-ID: <3B409F8F.7050408@xythos.com> (raw)
References: <200106301642.f5UGgkj14915@candle.pha.pa.us>
<3B3E7A94.209@xythos.com>
<00b801c102c4$fdd49ea0$4301a8c0@directi.com>
Arsalan,
Why do you consider semi colons outside of quotes to be an error condition?
It is legal under postgresql to execute multiple SQL statements under
one call to the server. For example you can execute:
update foo set bar = ?; select * from foo;
In one call to the server by setting the 'query' on the Statement or
Prepared statement object to be the entire string above.
As you can see from this example it is certainly therefore legal to have
a semi-colon outside of quotes.
As to your second point about escapeSQL escaping quotes, I don't see
anywhere in the JDBC spec that says that type of behavior is supposed to
happen. Do you have an example where you feel the behavior of the
escapeSQL method isn't conforming to the JDBC spec with regards to quote
handling?
thanks,
--Barry
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: barry@xythos.com, azaidi@directi.com, pgsql-jdbc@postgresql.org, pgman@candle.pha.pa.us
Subject: Re: [INTERFACES] New code for JDBC driver
In-Reply-To: <3B409F8F.7050408@xythos.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox