Re: Indices and user defined operators - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Indices and user defined operators
Date
Msg-id 42A7EF7C.2000808@archonet.com
Whole thread Raw
In response to Re: Indices and user defined operators  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tom Lane wrote:
> I wrote:
> 
>>"Dmitri Bichko" <dbichko@aveopharma.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


pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: [despammed] rejecting characters in a field
Next
From: Volkan YAZICI
Date:
Subject: Re: SELECT very slow