index on function - Mailing list pgsql-hackers

From You Lun
Subject index on function
Date
Msg-id 20030523053005.84345.qmail@web11404.mail.yahoo.com
Whole thread Raw
Responses Re: index on function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

I'm doing a course project extending PostgreSQL
somehow. One part of this is using an index on a
function. I thought it's easy to create an function
index initially. But later found that PostgreSQL only
allow functions taking one or more columns. But the
function I need to create index on takes composite
type. Specifically, a relation R, a user-defined
function f, f takes R (the composite type as its
argument), f returns a float. f is defined in C. I
want to create a function index like this:

create index idx on R (f(R))

But it doesn't pass PostgreSQL's grammar.

Any suggestion?



__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Text format protocol representation
Next
From: Antonis Antoniou
Date:
Subject: Re: Tetra-bytes database / large indexes needs