Re: Extension for PostgreSQL cast jsonb to hstore WIP

From: Антуан Виолин <violin(dot)antuan(at)gmail(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Extension for PostgreSQL cast jsonb to hstore WIP
Date: 2024-05-06 10:39:13
Message-ID: CAFjUV9wN2d533XBxH4ztMt4_juBgdt7950KQ=UE1vZVH2_Dycw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
cast_jsonb_to_hstore2.patch application/octet-stream 8.1 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Jakub Wartak 2024-05-06 10:55:27 Re: apply_scanjoin_target_to_paths and partitionwise join
Previous Message Alexander Korotkov 2024-05-06 10:19:25 Re: psql: fix variable existence tab completion