From: | You Lun <youlun2000(at)yahoo(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | index on function |
Date: | 2003-05-23 05:30:05 |
Message-ID: | 20030523053005.84345.qmail@web11404.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Antonis Antoniou | 2003-05-23 07:14:32 | Re: [HACKERS] Tetra-bytes database / large indexes needs |
Previous Message | Hannu Krosing | 2003-05-23 05:27:49 | Re: Text format protocol representation |