Re: jsonb concatenate operator's semantics seem questionable

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Peter Geoghegan <pg(at)heroku(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Marko Tiikkaja <marko(at)joh(dot)to>, Ryan Pedela <rpedela(at)datalanche(dot)com>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Ilya Ashchepkov <koctep(at)gmail(dot)com>
Subject: Re: jsonb concatenate operator's semantics seem questionable
Date: 2015-05-24 19:27:34
Message-ID: 55622626.1030207@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 05/24/2015 03:17 PM, Peter Geoghegan wrote:
> On Thu, May 21, 2015 at 2:25 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>> This change really makes this set of jsonb features quite a bit more
>> compelling. I'm glad I thought of it - wish I had done so earlier. So
>> notwithstanding the controversy upthread, I think this is a good result.
> I think that we should look into making jsonb support array-style
> subscripting within updates (to update "nested subdatums" directly).
> This would make the new concatenate operator a lot more compelling.
> Also, UPDATE targetlists don't accept a table qualification in their
> targetlist (for the assign-to column) because the parser similarly
> needs to support updating composite type's "nested subdatums"
> directly.
>
> Having gone to the trouble of making the parser support this stuff (in
> a way that makes us not follow the SQL standard in a couple of
> places), we ought to have a similar capability for jsonb. I haven't
> looked into it, but it seems like a good project for 9.6. I'm not
> volunteering to undertake the project, though.

Yes, sounds like it would be good. I too am not volunteering.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2015-05-24 21:16:49 Re: jsonb concatenate operator's semantics seem questionable
Previous Message Peter Geoghegan 2015-05-24 19:17:35 Re: jsonb concatenate operator's semantics seem questionable