| 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: | Whole Thread | Raw Message | 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 |