dex test_idx on test USING GIN ((testfct(data)));
SET enable_seqscan TO off;
EXPLAIN ANALYZE select * from test where testfct(data) @> ARRAY['testdata-one'];
this does the trick.
cheers,
F
On 2013-02-06, at 1:15 PM, Francois Payette wrote:
> Greetings!
>
> I need the foll
Greetings!
I need the following: create an index on multiple values for a single row. My
other solution consists of a lot of duplicated rows in seperate tables and
triggers and indexes, resulting in slower performance.
The following fails on 9.2, it says ERROR: index expression cannot return a
