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

On 02/06/2013 12:34 PM, Merlin Moncure wrote:
>
> The point is that Postgres should not introduce language constraints
> because of broken driver technology.

+1

> To move forward in your
> particular case, consider:
> *) switching to 'hstore defined()' function:

good solution - but just use the existing "exist()" function.

> *) hacking pg_operator (carefully look up and change oprname for the
> specific hstore operator)

bad solution. Why not just provide an additional operator?
   CREATE OPERATOR ~ (        LEFTARG = hstore,        RIGHTARG = text,        PROCEDURE = exist,        RESTRICT =
contsel,       JOIN = contjoinsel   );
 


cheers

andrew