From: | Herman Bergwerf <hermanbergwerf(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Extend GIN |
Date: | 2017-03-18 16:31:56 |
Message-ID: | CAPAjOT0cP9cgOdcLv71bPG5h+L21z+5vOMbHbBAAigK-nab83g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi! I am building a database with mathematical expressions. For example
something like '1+x/y'. I want to try to create an index to quickly find
records that match a pattern like '?a + ?b' ('1+x/y' is an example of
this). Is this feasible? (the jsquery project is doing something a little
like this) I do not know much about complicated indexes. I looked at the
GIN index which is somehow able to index contains and contained by. For
example in some way 1+x/y contains ?a+?b. I thought about creating a
function in Lua to check this and create an operator class to make this
work with the GIN index. Is something like that possible? Could it actually
work?
Thanks,
Herman
From | Date | Subject | |
---|---|---|---|
Next Message | Andrea Bonomelli | 2017-03-22 10:39:25 | backup task target |
Previous Message | Neha Khatri | 2017-03-13 05:11:56 | Re: [NOVICE] Why is there a doubtful copyObject call in add_vars_to_targetlist |