Re: index on user defined type - Mailing list pgsql-general

From Tom Lane
Subject Re: index on user defined type
Date
Msg-id 2316.1105571557@sss.pgh.pa.us
Whole thread Raw
In response to Re: index on user defined type  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: index on user defined type  (Jeff Davis <jdavis-pgsql@empires.org>)
List pgsql-general
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> I'm wondering if the function under = is an SQL function being inlined.

Bingo --- that's surely it.  After inlining, the expression would no
longer look like it matched the index.

You don't want to use SQL functions to define indexable operators
anyway.  They leak memory, and are slow, and neither of those are
good properties for an index support function.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joost Kraaijeveld"
Date:
Subject: Re: How to return a resultset/table from a sql function?
Next
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: Postgresql Text field / Visual FoxPro Memo and ODBC