Re: jsonb and nested hstore - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: jsonb and nested hstore
Date
Msg-id CAM3SWZQTuzjWiZQDzBiBajak+dsSVafZmhB-m2fvfE+17P8yaw@mail.gmail.com
Whole thread Raw
In response to Re: jsonb and nested hstore  (Oleg Bartunov <obartunov@gmail.com>)
Responses Re: jsonb and nested hstore  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-hackers
On Tue, Mar 4, 2014 at 1:30 AM, Oleg Bartunov <obartunov@gmail.com> wrote:
> Thanks, looks like a bug.

I guess this is down to the continued definition of gin_hstore_ops as
an opclass with text storage?:

+ CREATE OPERATOR CLASS gin_hstore_ops
+ DEFAULT FOR TYPE hstore USING gin
+ AS
+     OPERATOR        7       @>,
+     OPERATOR        9       ?(hstore,text),
+     OPERATOR        10      ?|(hstore,text[]),
+     OPERATOR        11      ?&(hstore,text[]),
+     FUNCTION        1       bttextcmp(text,text),
+     FUNCTION        2       gin_extract_hstore(internal, internal),
+     FUNCTION        3       gin_extract_hstore_query(internal,
internal, int2, internal, internal),
+     FUNCTION        4       gin_consistent_hstore(internal, int2,
internal, int4, internal, internal),
+     STORAGE         text;


-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: KONDO Mitsumasa
Date:
Subject: Re: Add min and max execute statement time in pg_stat_statement
Next
From: Atri Sharma
Date:
Subject: Re: ALTER TABLE lock strength reduction patch is unsafe