Re: ERROR: operator does not exist: json = json

On 2022-07-08 Fr 07:57, Dagfinn Ilmari Mannsåker wrote: > Erik Rijkers writes: > >> Hi, >> >> Comparison of 2 values of type jsonb is allowed. >> >> Comparison of 2 values of type json gives an error. >> >> That seems like an oversight -- or is it deliberate? > This is because json is just a tex

Re: ERROR: operator does not exist: json = json

Erik Rijkers writes: > Hi, > > Comparison of 2 values of type jsonb is allowed. > > Comparison of 2 values of type json gives an error. > > That seems like an oversight -- or is it deliberate? This is because json is just a textual representation, and different JSON strings can be semantically e