Re: [GENERAL] Request for review of new redis-fdw module

2015-01-31 Thread Leon Dang
Redis PUBLISH is now supported so you can send messages to subscribers on a channel. Leon On Wed, Jan 28, 2015 at 12:23 AM, Leon Dang wrote: > The code has been posted to https://github.com/nahanni/rw_redis_fdw > > Anyone interested can test it out or review it. > > cheers > Leon > > > > Leon

[GENERAL] Checking if a json-typed column contains a key

2015-01-31 Thread Wells Oliver
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 wellsoli...@gmail.com

Re: [GENERAL] Checking if a json-typed column contains a key

2015-01-31 Thread Paul Jungwirth
> With the hstore you can do hstore ? 'key' to check if the object contains > the key-- is there a similar function for json objects? Is this good enough?: => select ('{"a":1,"b":null}'::json) -> 'a'; ?column? -- 1 => select ('{"a":1,"b":null}'::json) -> 'b'; ?column? -- null