Re: Alias hstore's ? to ~ so that it works with JDBC

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Seamus Abshere <seamus(at)abshere(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Alias hstore's ? to ~ so that it works with JDBC
Date: 2013-02-06 16:58:13
Message-ID: CAHyXU0zstU7FKiJQbYjYa_h4v_wh1UAwGHtQg-3MsbOSS3Hm9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Feb 5, 2013 at 11:29 AM, Seamus Abshere <seamus(at)abshere(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2013-02-06 17:05:35 Re: sql_drop Event Trigger
Previous Message Heikki Linnakangas 2013-02-06 16:36:38 Re: [COMMITTERS] pgsql: Fast promote mode skips checkpoint at end of recovery.