| From: | Nilesh Phadke <nphadke(at)csgrad(dot)cs(dot)vt(dot)edu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Functional Indices |
| Date: | 2000-02-05 06:03:33 |
| Message-ID: | 389BBD34.378EB91A@csgrad.cs.vt.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I want to create functional index for a C function that i have written.
the function looks like....
float8
fx(float8,float8) {
..
}
I also have a table T(x1,x2) where x1 and x2 are attributes of type
float8.
The function takes x1,x2 as inputs and outputs fx(x1,x2) ...
How do i create an index on fx(x1,x2) ????
I tried the documnetation but there are no good examples for functional
indices....
Any help is would be really nice...
My e-mail :- nilesh(at)vt(dot)edu
Thanks in advance
Nilesh.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nilesh Phadke | 2000-02-05 06:11:04 | functional indices |
| Previous Message | Ed Loehr | 2000-02-05 05:46:01 | [GENERAL] Troubles with PL/pgSQL trigger/function drop/create scripts |