Re: index on user defined type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Jeff Davis <jdavis-pgsql(at)empires(dot)org>, PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: index on user defined type
Date: 2005-01-12 23:12:37
Message-ID: 2316.1105571557@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MargaretGillon 2005-01-12 23:23:27 Re: Postgresql Text field / Visual FoxPro Memo and ODBC
Previous Message Joost Kraaijeveld 2005-01-12 23:06:58 Re: How to return a resultset/table from a sql function?