From: Atesz <atesz@ritek.hu>
To: pgsql-sql@postgresql.org
Subject: Own opclass and LIKE problem again!
Date: Mon, 26 Apr 2004 12:11:50 +0200
Message-ID: <000101c42b76$e7125490$0b02010a@atesz> (raw)
Hi!
Thank you very much the answers for my previous 'Multi ordered select
and indexing' question! I tried your suggestions, and those are working
well. We found a problem when used '(-col2)' instead of 'col2 DESC'.
This solution working as a functional index and in our experience when
the planner evaluates the cost of using this functional index, it uses
0.5% of the table's size. Usually this estimate is bad, and the query is
slow. Why is it working such? Preferably should I ask this on the
HACKERS or PERFORMANCE list?
But my main question how can I force the LIKE operator for using my own
operator class. I can create own LIKE operator, but it won't use my
reverse order operator class (and its indexes). How can I exchange the
standard LIKE operator with my own, which use my special reverse order
indexes?
For examle: (~~ means LIKE)
col ~~ 'asd%' working as ((col >= 'asd'::text) AND (col <
'ase'::text))
I'd like to see the next:
col /~~ 'asd%' working as ((col />= 'asd'::text) AND (col /<
'ase'::text))
Can somebody help us?
Thanks in advance.
Antal Attila
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: atesz@ritek.hu
Subject: Re: Own opclass and LIKE problem again!
In-Reply-To: <000101c42b76$e7125490$0b02010a@atesz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox