ERROR: operator does not exist: json = json - Mailing list pgsql-hackers

From Erik Rijkers
Subject ERROR: operator does not exist: json = json
Date
Msg-id 267c8386-5b23-c4fd-cd5a-57fe11e42858@xs4all.nl
Whole thread Raw
Responses Re: ERROR: operator does not exist: json = json
List pgsql-hackers
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?

Example:

select '42'::json = '{}'::json;
--> ERROR:  operator does not exist: json = json

(of course, easily 'solved' by casting but that's not really the point)


Thanks,

Erik Rijkers







pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: Re: [PoC] Improve dead tuple storage for lazy vacuum
Next
From: Julien Rouhaud
Date:
Subject: Re: Allow file inclusion in pg_hba and pg_ident files