Re: Indices and user defined operators

From: Richard Huxton <dev(at)archonet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dmitri Bichko <dbichko(at)aveopharma(dot)com>, Sql-Postgre <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Indices and user defined operators
Date: 2005-06-09 07:27:56
Message-ID: 42A7EF7C.2000808@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane wrote:
> I wrote:
>
>>"Dmitri Bichko" <dbichko(at)aveopharma(dot)com> writes:
>>
>>>So, is there any way to make these operators use an index defined as
>>>above?
>
>
>>If you've set things up so that the operators are defined by inline-able
>>SQL functions, I'd sort of expect it to fall out for free ...

Now *that* is very nice. Thanks for the example Tom - nice to know the
sql list is still teaching me things within the first 5 messages I read.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Volkan YAZICI 2005-06-09 07:31:50 Re: SELECT very slow
Previous Message Michael Glaesemann 2005-06-09 07:23:18 Re: [despammed] rejecting characters in a field