Re: SQL/JSON revisited - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: SQL/JSON revisited
Date
Msg-id 20230329102758.trybzdwbwajrf4mv@alvherre.pgsql
Whole thread Raw
In response to Re: SQL/JSON revisited  (Erik Rijkers <er@xs4all.nl>)
Responses Re: SQL/JSON revisited  (Erik Rijkers <er@xs4all.nl>)
Re: SQL/JSON revisited  (Alexander Lakhin <exclusion@gmail.com>)
List pgsql-hackers
On 2023-Mar-28, Erik Rijkers wrote:

> In the json_arrayagg() description, it says:
> 'If ABSENT ON NULL is specified, any NULL values are omitted.'
> That's true, but as omitting NULL values is the default (i.e., also without
> that clause) maybe it's better to say:
> 'Any NULL values are omitted unless NULL ON NULL is specified'

Doh, somehow I misread your report and modified the json_object()
documentation instead after experimenting with it (so now the
ABSENT/NULL ON NULL clause is inconsistenly described everywhere).
Would you mind submitting a patch fixing this mistake?

... and pushed it now, after some more meddling.

I'll rebase the rest of the series now.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"Entristecido, Wutra                     (canción de Las Barreras)
echa a Freyr a rodar
y a nosotros al mar"



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Schema variables - new implementation for Postgres 15
Next
From: Dagfinn Ilmari Mannsåker
Date:
Subject: Tab completion for AT TIME ZONE