At the moment, this cast supports only these structures, as it was enough for my tasks: {str:numeric} {str:str} {str:bool} {str:null} But it's a great idea and I'll think about implementing it.
вт, 2 апр. 2024 г. в 19:48, Andrew Dunstan <and...@dunslane.net>: > > On 2024-04-02 Tu 07:07, ShadowGhost wrote: > > 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! > > > > One reason we don't have such a cast is that hstore has a flat > structure, while json is tree structured, and it's not always an object > / hash. Thus it's easy to reliably cast hstore to json but far less easy > to cast json to hstore in the general case. > > What do you propose to do in the case or json consisting of scalars, or > arrays, or with nested elements? > > > cheers > > > andrew > > > > -- > Andrew Dunstan > EDB: https://www.enterprisedb.com > >