ERROR: operator does not exist: json = json

Поиск
Список
Период
Сортировка
От Erik Rijkers
Тема ERROR: operator does not exist: json = json
Дата
Msg-id 267c8386-5b23-c4fd-cd5a-57fe11e42858@xs4all.nl
обсуждение исходный текст
Ответы Re: ERROR: operator does not exist: json = json
Список 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 по дате отправления: