Re: jsonb and nested hstore

* 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