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

2023-08-21 Thread Amit Langote
On Fri, Aug 18, 2023 at 2:59 PM Peter Eisentraut wrote: > On 16.08.23 16:59, Merlin Moncure wrote: > > On Wed, Aug 16, 2023 at 8:55 AM Peter Eisentraut > > wrote: > > > > This warning comes from parse_expr.c transformJsonValueExpr() and is > > triggered for

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

2023-08-18 Thread Peter Eisentraut
On 16.08.23 16:59, Merlin Moncure wrote: On Wed, Aug 16, 2023 at 8:55 AM Peter Eisentraut > wrote: This warning comes from parse_expr.c transformJsonValueExpr() and is triggered for example by the following test case: SELECT JSON_OBJECT('foo':

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

2023-08-16 Thread Merlin Moncure
On Wed, Aug 16, 2023 at 8:55 AM Peter Eisentraut wrote: > 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

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

2023-08-16 Thread Peter Eisentraut
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