Checking if a json-typed column contains a key

From: Wells Oliver <wellsoliver(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Checking if a json-typed column contains a key
Date: 2015-01-31 23:23:27
Message-ID: CAOC+FBX+p6AsXpPvw4_kfefqBYO-d5V1YHfR8x2tBhy=9+zTnQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

With the hstore you can do hstore ? 'key' to check if the object contains
the key-- is there a similar function for json objects?

(still on 9.3 so no jsonb)

--
Wells Oliver
wellsoliver(at)gmail(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Jungwirth 2015-02-01 00:49:47 Re: Checking if a json-typed column contains a key
Previous Message Roger Pack 2015-01-31 13:55:31 Re: Fwd: [GENERAL] 4B row limit for CLOB tables