Re: Extension for PostgreSQL cast jsonb to hstore WIP

On Mon, Jul 15, 2024 at 12:44 PM Антуан Виолин wrote: > 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 t

Re: Extension for PostgreSQL cast jsonb to hstore WIP

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 f

Re: Extension for PostgreSQL cast jsonb to hstore WIP

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 frac

Re: Extension for PostgreSQL cast jsonb to hstore WIP

On 2024-04-02 Tu 11:43, ShadowGhost wrote: 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. Please don't top-post on the PostgreSQL lists. See

Re: Extension for PostgreSQL cast jsonb to hstore WIP

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 : > > On 2024-04-02 Tu 07:07, ShadowGhost wrote: > > Hello a

Re: Extension for PostgreSQL cast jsonb to hstore WIP

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 decide

Extension for PostgreSQL cast jsonb to hstore WIP

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 bu