ZomboDB Query

[Ranjit Chavan]

Hi

i have postgres version 9.3, 9.4, 9.5 and  Elasticsearch 1.7.1+ (not 2.0)

i have on one postgres database xyz and having 3 schema like schema a,schema b,schema c have same structure and i have created one view on table name like test from three schema.

now i want use Zombodb index on that view is it possible use Zombodb on that view or any other way to use get result from that three schema

[Eric Ridge]

Hi Ranjit!

It's important to note that ZDB indexes *tables*, not views.  As such, ZomboDB indexes aren't really any different than standard btree indexes, except that a ZDB index generally wants to cover all columns in a table.  So in general, whatever strategies you might use for joining tables and creating views all apply with ZDB.

That said, ZDB provides some advanced use features for linking indexes together.  You can read about all that stuff, which includes examples, here:  https://github.com/zombodb/zombodb/blob/master/INDEX-OPTIONS.md

If you're struggling with something specific, I'd appreciate some SQL that demonstrates what you're trying to do.  With that, I can probably provide more detailed information.

eric

--
You received this message because you are subscribed to the Google Groups "ZomboDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to zombodb+u...@googlegroups.com.
To post to this group, send email to zom...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/zombodb/CAFRW%3D8rZkW_QHUmEx-ZiVgO_PArWFa%3DG6cC3dnb4ninh5HtzSg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.