Re: index on user defined type

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

Jeff Davis <jdavis-pgsql(at)empires(dot)org> writes:
> I attached a proposed documentation patch. I wasn't able to readily see
> the implications of writing a function in SQL regarding an index, so
> perhaps this will help someone in the future (not that many people will
> attempt writing index access methods in SQL, but someone could get
> confused like I did).

Actually the inlining issue is only a problem for the operators, not the
support functions (since the support functions don't appear in queries
that are going to use the index). I applied a modified version of your
patch.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2005-01-14 01:45:05 Re: Version Control Software for Database Objects
Previous Message Clodoaldo Pinto 2005-01-14 00:58:24 7.4.6 FC2 MUCH slower from 2.6.9-1.11 to 2.6.10-1.8