Extension for PostgreSQL cast jsonb to hstore WIP

From: ShadowGhost <violin05082003(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Extension for PostgreSQL cast jsonb to hstore WIP
Date: 2024-04-02 11:07:47
Message-ID: CAOsjGuOGk=j3B6tjTfBm4WSBtek8vkhdSK924RMFmW90nojuvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello all.
Recently, when working with the hstore and json formats, I came across the
fact that PostgreSQL has a cast of hstore to json, but there is no reverse
cast. I thought it might make it more difficult to work with these formats.
And I decided to make a cast json in the hstore. I used the built-in jsonb
structure to create it and may have introduced methods to increase
efficiency by 25% than converting the form jsonb->text->hstore. Which of
course is a good fact. I also wrote regression tests to check the
performance. I think this extension will improve the work with jsonb and
hstore in PostgreSQL.
If you've read this far, thank you for your interest, and I hope you enjoy
this extension!
---- Antoine

Attachment Content-Type Size
cast_jsonb_to_hstore.patch application/x-patch 9.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey M. Borodin 2024-04-02 11:35:28 Re: Allow non-superuser to cancel superuser tasks.
Previous Message torikoshia 2024-04-02 10:34:45 Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)