Re: jsonb and nested hstore - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: jsonb and nested hstore
Date
Msg-id 20140228022700.GV2921@tamriel.snowman.net
Whole thread Raw
In response to Re: jsonb and nested hstore  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
* Peter Geoghegan (pg@heroku.com) wrote:
> On Thu, Feb 27, 2014 at 6:08 PM, Stephen Frost <sfrost@snowman.net> wrote:
> > Extensions can't depend on other extensions directly- hence you can't
> > write an extension that depends on hstore, which sucks.  It'd be
> > preferrable to not have that issue w/ json/jsonb/whatever.
>
> I think it depends of what you mean by "depend". The earthdistance
> extension "requires" 'cube', for example, "a data type cube for
> representing multidimensional cubes". Although I am aware of the
> lengths that drivers like psycopg2 go to to support hstore because
> it's an extension, which is undesirable.

What earthdistance does is simply use the 'cube' data type- that's quite
different from needing to be able to make calls from one .so into the
other .so directly.  With earthdistance/cube, everything goes through
PG.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: jsonb and nested hstore
Next
From: Peter Eisentraut
Date:
Subject: Re: tests for client programs