Postgres uses ? as an operator; may its JDBC driver allow escaping?

[Lance Andersen - Oracle]

On Feb 11, 2013, at 4:02 PM, Mark Rotteveel wrote:

> On 11-2-2013 21:44, Mark Rotteveel wrote:
>> Lets be practical: the SQL standard defines a lot of things that don't
>> match with reality, and PostgreSQL does actually have the ? as an
>> operator which currently isn't supported by their JDBC driver.
> 
> The JDBC spec section 6.2 (Guidelines and Requirements) says:
> "Drivers should provide access to every feature implemented by the underlying data source, including features that extend the JDBC API. The intent is for applications using the JDBC API to have access to the same feature set as native applications."
> 
> That guideline in this case is a bit hard to actually follow ;)

Right but there is nothing that prevents Postgres from doing that either via a specific method or some other creative means which is what other driver vendors do.

How they do it is up to them, they just have to innovate in a way that is not going to handcuff them (or have say a PostgresStatementExt class, does not matter )

Better yet, have Postgres petition the Ansi Standard committee to also support '?' as an operator :-)
> 
> Mark
> -- 
> Mark Rotteveel

-------------- next part --------------

Lance Andersen| Principal Member of Technical Staff | +1.781.442.2037
Oracle Java Engineering 
1 Network Drive 
Burlington, MA 01803
Lance.Andersen at oracle.com