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

That would seem to be the implication. JDBC wouldn't really know anything about hstore.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On Fri, Feb 8, 2013 at 12:51 PM, Andrew Dunstan <andrew@dunslane.net> wrote:

On 02/08/2013 12:41 PM, Kris Jurka wrote:

On Fri, 8 Feb 2013, Dave Cramer wrote:

Would this be an postgresql specific escape sequence ? I don't think the
spec allows for this does it ?

Yes, this would be a postgresql jdbc driver specific escape.  The spec
doesn't have a concept of private escape sequences, but that doesn't seem
like the end of the world.  Clearly the user here is writing postgresql
specific code to use hstore operators, so there's not a portability loss
here.

I assume, though, that you're not talking about something that's hstore-specific, but rather something that will allow the user to put a non-parameter question mark in the query string. As has been noted upthread, the hstore use is far from the only one that causes users to trip on this.

cheers

andrew