[NOVICE] Extend GIN - Mailing list pgsql-novice

From Herman Bergwerf
Subject [NOVICE] Extend GIN
Date
Msg-id CAPAjOT0cP9cgOdcLv71bPG5h+L21z+5vOMbHbBAAigK-nab83g@mail.gmail.com
Whole thread Raw
Responses Re: Extend GIN  (Merlin Moncure <mmoncure@gmail.com>)
List 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

pgsql-novice by date:

Previous
From: Neha Khatri
Date:
Subject: [NOVICE] Why is there a doubtful copyObject call in add_vars_to_targetlist
Next
From: Andrea Bonomelli
Date:
Subject: [NOVICE] backup task target