Re: jsonb concatenate operator's semantics seem questionable

Поиск
Список
Период
Сортировка
Искать
От
Peter Geoghegan
Тема
Re: jsonb concatenate operator's semantics seem questionable
Дата
в 17:43:29
Msg-id
CAM3SWZRV6wXoQKyTiw4hqbOSvL-v_jE8YNvzwYoY5FWmDt1ODA@mail.gmail.com
Ответ на
Список
Дерево обсуждения
jsonb concatenate operator's semantics seem questionable Peter Geoghegan <pg@heroku.com>
Re: jsonb concatenate operator's semantics seem questionable Robert Haas <robertmhaas@gmail.com>
Re: jsonb concatenate operator's semantics seem questionable Andrew Dunstan <andrew@dunslane.net>
Re: jsonb concatenate operator's semantics seem questionable Petr Jelinek <petr@2ndquadrant.com>
Re: jsonb concatenate operator's semantics seem questionable Dmitry Dolgov <9erthalion6@gmail.com>
Re: jsonb concatenate operator's semantics seem questionable Peter Geoghegan <pg@heroku.com>
Re: jsonb concatenate operator's semantics seem questionable Andrew Dunstan <andrew@dunslane.net>
Re: jsonb concatenate operator's semantics seem questionable Peter Geoghegan <pg@heroku.com>
Re: jsonb concatenate operator's semantics seem questionable Robert Haas <robertmhaas@gmail.com>
Re: jsonb concatenate operator's semantics seem questionable Peter Geoghegan <pg@heroku.com>
Re: jsonb concatenate operator's semantics seem questionable Peter Geoghegan <pg@heroku.com>
Re: jsonb concatenate operator's semantics seem questionable "Ilya I. Ashchepkov" <koctep@gmail.com>
On Mon, May 18, 2015 at 10:29 AM, Andrew Dunstan  wrote:
> Having trouble scanning this. Since hstore isn't nested what the heck does
> "nested assignment" mean w.r.t. hstore?

It means assigning to one "subdatum" in the hstore datum, as opposed
to simply assigning an entirely new hstore (granted, that's what
you're actually doing with the nested assignment, but conceptually
you're assigning to a "subdatum" when using the "hstore ||" idiom that
the hstore docs prominently talk about).

> In any case, it seems clear from other posters that your perceptions and
> expectations are not universally held.

I think that my expectations are pretty widely held. People want to be
able to assign to nested elements of a jsonb. Unfortunately, this
doesn't get them any closer, because many layers of nesting are normal
with jsonb. Let's be clear on that.
-- 
Peter Geoghegan


В списке pgsql-hackers по дате отправления
От: Andrew Dunstan
Дата:
От: Jeff Janes
Дата:
Сообщение: Re: WALWriteLock contention
FAQ