dubious warning: FORMAT JSON has no effect for json and jsonb types

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема dubious warning: FORMAT JSON has no effect for json and jsonb types
Дата
Msg-id dfec2cae-d17e-c508-6d16-c2dba82db486@eisentraut.org
обсуждение исходный текст
Ответы Re: dubious warning: FORMAT JSON has no effect for json and jsonb types  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
This warning comes from parse_expr.c transformJsonValueExpr() and is 
triggered for example by the following test case:

SELECT JSON_OBJECT('foo': NULL::json FORMAT JSON);
WARNING:  FORMAT JSON has no effect for json and jsonb types

But I don't see anything in the SQL standard that would require this 
warning.  It seems pretty clear that FORMAT JSON in this case is 
implicit and otherwise without effect.

Also, we don't have that warning in the output case (RETURNING json 
FORMAT JSON).

Anyone remember why this is here?  Should we remove it?



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Handle infinite recursion in logical replication setup
Следующее
От: Önder Kalacı
Дата:
Сообщение: Re: postgres_fdw: wrong results with self join + enable_nestloop off