Re: json (b) and null fields - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: json (b) and null fields
Date
Msg-id 20140929144524.GS16422@tamriel.snowman.net
Whole thread Raw
In response to Re: json (b) and null fields  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: json (b) and null fields  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> +1.  I am sort of surprised that anyone things this null-stripping
> behavior is something that ought to be part of core PostgreSQL instead
> of, I don't know, relegated to an extension somewhere far from the
> bright center of the galaxy.  I've never heard of that requirement
> anywhere but here.  But if other people feel we should have it, that's
> fine - but certainly making it a separate function makes a lot more
> sense.

I'm not at all surprised by the request, and I do believe it to be
worthwhile to have in core as it's a pretty common pattern with JSON.
That said, making it part of an operator function wasn't the right
approach and it should be an independent function.

Once I've caught up on things this morning, I'll revert the original
commit and ping Pavel about an alternative implementation, with an
independent function, which also handles complex JSON (unless anyone
else wants to volunteer to work on it..).
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch to support SEMI and ANTI join removal
Next
From: Robert Haas
Date:
Subject: Re: Replication identifiers, take 3