Postgres Pro
Downloads
Home   >   mailing lists

Re: Alias hstore's ? to ~ so that it works with JDBC - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Alias hstore's ? to ~ so that it works with JDBC
Date
Msg-id CAHyXU0zstU7FKiJQbYjYa_h4v_wh1UAwGHtQg-3MsbOSS3Hm9Q@mail.gmail.com
Whole thread Raw
In response to Alias hstore's ? to ~ so that it works with JDBC  (Seamus Abshere <seamus@abshere.net>)
Responses Re: Alias hstore's ? to ~ so that it works with JDBC
List pgsql-hackers
Tree view 
On Tue, Feb 5, 2013 at 11:29 AM, Seamus Abshere <seamus@abshere.net> wrote:
> hi,
>
> As reported in BUG #7715 [1], hstore's use of ? as an operator conflicts
> with JDBC's bind variables.
>
> I think we could just alias ? to ~ and tell JDBC users to use that instead.
> [2]

This is not a bug with postgres, but with java/JDBC. There are many
operators that use '?' besides hstore and JDBC should allow for
escaping out of its statement interpretation.

merlin

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: [COMMITTERS] pgsql: Fast promote mode skips checkpoint at end of recovery.
Next
From: Robert Haas
Date:
Subject: Re: sql_drop Event Trigger