dubious warning: FORMAT JSON has no effect for json and jsonb types - Mailing list pgsql-hackers

From Peter Eisentraut
Subject dubious warning: FORMAT JSON has no effect for json and jsonb types
Date
Msg-id dfec2cae-d17e-c508-6d16-c2dba82db486@eisentraut.org
Whole thread Raw
Responses Re: dubious warning: FORMAT JSON has no effect for json and jsonb types
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Handle infinite recursion in logical replication setup
Next
From: Önder Kalacı
Date:
Subject: Re: postgres_fdw: wrong results with self join + enable_nestloop off