Re: Extension for PostgreSQL cast jsonb to hstore WIP

Started by Антуан Виолинover 2 years ago1 messageshackers
Beta feature

Hackorum builds and tests every patch posted to the lists, not only commitfest submissions. This is Hackorum's own CI rather than the PostgreSQL project's, and it is still under testing - please report anything that looks wrong.

appliessuccessCI history

You can run a PostgreSQL built from this patch straight from Docker, with no checkout and no build:

docker run --rm -p 5432:5432 ghcr.io/hackorum-dev/postgres-patch:t49581
psql -h localhost -U postgres

Built from patchset v1 (message #1), August 17, 2026 at 09:52 AM.

Jump to latest
#1Антуан Виолин
violin.antuan@gmail.com

On 2024-04-03 Wn 04:21, Andrew Dunstan

I don't think a cast that doesn't cater for all the forms json can take

is going to work very well. At the very least you would need to error out
in cases you didn't want to cover, and have tests for all of > > those
errors. But the above is only a tiny fraction of those. If the error cases
are going to be so much more than the cases that work it seems a bit
pointless.
Hi everyone
I changed my mail account to be officially displayed in the correspondence.
I also made an error conclusion if we are given an incorrect value. I
believe that such a cast is needed by PostgreSQL since we already have
several incomplete casts, but they perform their duties well and help in
the right situations.

cheers

Antoine

Attachments:

cast_jsonb_to_hstore2.patchapplication/octet-stream; name=cast_jsonb_to_hstore2.patchDownload+258-0