On 01/23/2015 07:40 AM, Tim Smith wrote:
re: (a)see the documentation pertaining to 'jsonb indexing', to wit: -- Find documents in which the key "company" has value "Magnafone" SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @> '{"company": "Magnafone"}';Nope, sorry, tried that. Doesn't work for me. Hence the question. ;-)
How does it not work? In other words what was the query you tried and what was the output? -- Adrian Klaver [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
