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

2013-02-13 Thread Seamus Abshere
nce/Mark How to decide? Best, Seamus [1] http://mail.openjdk.java.net/pipermail/jdbc-spec-discuss/2013-February/58.html [2] http://mail.openjdk.java.net/pipermail/jdbc-spec-discuss/2013-February/date.html#51 (threaded view gets it out of order) -- Seamus Abshere sea...@abshere.net https://github.com

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

2013-02-11 Thread Seamus Abshere
On 2/11/13 11:30 AM, Tom Lane wrote: It would take extremely deep knowledge of SQL syntax for the driver to reliably tell the difference between a variable and an operator Yes, auto-detecting the difference between bind vars and operators would probably be even more difficult than providing es

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

2013-02-08 Thread Seamus Abshere
merlin, I appreciate your perspective and wish that JDBC didn't present this problem. Still, with the rapidly growing adoption of both Postgres and JVM-based languages (thanks Heroku!) - plus the special power of hstore - I think it would be a shame if such a small accommodation could not be

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

2013-02-08 Thread Seamus Abshere
ate JDBC on the Postgres side, though, is going to prevent hstore from being used properly with Java or any JVM-based language like JRuby. Please let me know if my assumptions are wrong. Best, Seamus On 2/6/13 10:58 AM, Merlin Moncure wrote: On Tue, Feb 5, 2013 at 11:29 AM, Seamus Absh

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

2013-02-06 Thread Seamus Abshere
indexes, I think you also have to do CREATE OPERATOR CLASS [1] Best, Seamus [1] See my revision of hstore--1.1.sql at https://gist.github.com/seamusabshere/4715959/revisions -- Seamus Abshere sea...@abshere.net https://github.com/seamusabshere -- Sent via pgsql-hackers mailing

[HACKERS] Alias hstore's ? to ~ so that it works with JDBC

2013-02-05 Thread Seamus Abshere
ql.org [2] https://gist.github.com/seamusabshere/4715959/revisions -- Seamus Abshere sea...@abshere.net https://github.com/seamusabshere -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers