On Wed, Aug 26, 2015 at 10:02:26PM -0400, Bruce Momjian wrote:
> On Wed, Jun 24, 2015 at 06:11:20PM -0400, David G. Johnston wrote:
> > http://www.postgresql.org/docs/devel/static/app-psql.html
> >
> > The other pset keywords with black-slash aliases include a "(or )"
> > paren after the keyword.
In studying our JSONB operators, I was confused about what they do based
on the docs. I found that "contain within" means "contain the
path/value", i.e. it has to match the path from the top level, not just
anywhere inside the document:
SELECT '{"a":1, "c" : {"b":2}}'::jsonb @> '{"a":1}':
On Sat, May 16, 2015 at 08:37:59AM -0400, Bruce Momjian wrote:
> We have made major improvements in GIN in the past few releases,
> particularly 9.4, but the full text search docs recommending when to use
> GIN and GiST indexes have not been updated. This blog post empirically
> shows many of the
