From: Richard Huxton <dev@archonet.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dmitri Bichko <dbichko@aveopharma.com>
Cc: Sql-Postgre <pgsql-sql@postgresql.org>
Subject: Re: Indices and user defined operators
Date: Thu, 09 Jun 2005 08:27:56 +0100
Message-ID: <42A7EF7C.2000808@archonet.com> (raw)
In-Reply-To: <7273.1118294824@sss.pgh.pa.us>
References: <F18A6F7CF1661F46920F2CF713122FED46CBAF@mail.aveo.aveopharma.com>
<6338.1118289716@sss.pgh.pa.us>
<7273.1118294824@sss.pgh.pa.us>
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
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: dev@archonet.com, tgl@sss.pgh.pa.us, dbichko@aveopharma.com
Subject: Re: Indices and user defined operators
In-Reply-To: <42A7EF7C.2000808@archonet.com>
* 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