Re: [GENERAL] Question about jsonb and data structures

2017-06-21 Thread Paul Jones
On Wed, Jun 21, 2017 at 09:37:20AM -0700, Emilie Laffray wrote: > Date: Wed, 21 Jun 2017 09:37:20 -0700 > From: Emilie Laffray <emilie.laff...@gmail.com> > To: Achilleas Mantzios <ach...@matrix.gatewaynet.com> > Cc: pgsql-general@postgresql.org > Subject: Re: [GE

Re: [GENERAL] Question about jsonb and data structures

2017-06-21 Thread Emilie Laffray
Hello Achilleas, I fail to see how it would solve my problem here. I already have a structure that is packed and nested. Your example is on a simple key/value pair structure and effectively you can address the ids very simply. In my case, I would need to return only a subset of the json data.

Re: [GENERAL] Question about jsonb and data structures

2017-06-21 Thread Achilleas Mantzios
On 21/06/2017 01:01, Emilie Laffray wrote: Hello, I have been playing with Postgresql recently with a large table and I have started looking at reducing the number of rows in that table. One idea to reduce the actual size, I thought I would "compress" the data structure into a JSON object