> > I could align ZSON to PostgreSQL code style. I only need to run pgindent > > and write a few comments. Do you think community would be interested in > > adding it to /contrib/ ? I mean doesn't ZSON solve a bit too specific > > problem for this? > > CREATE COMPRESSION DICTIONARY public.simple_dict ( > WORDS = my_json_schema > ); > > Then use the dictionary by referencing the DictionaryId within the > datatype modifier, e.g. ZSON(357) > > That way we can use this for TEXT, XML, JSON etc.. as ZTEXT, ZXML, ZJSON > > So it seems like a generally useful thing to me. Good idea! What about evolving schema of JSON/JSONB/XML? For instance, adding/removing keys in new versions of the application. UPDATE COMPRESSION DICTIONARY? -- Best regards, Aleksander Alekseev
Attachment:
signature.asc
Description: PGP signature
