functional indices

Поиск
Список
Период
Сортировка
От Nilesh Phadke
Тема functional indices
Дата
Msg-id 389BBEF8.5232DEF1@csgrad.cs.vt.edu
обсуждение исходный текст
Список 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...

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...
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@vt.edu

Thanks in advance
Nilesh.



В списке pgsql-general по дате отправления:

Предыдущее
От: Nilesh Phadke
Дата:
Сообщение: Functional Indices
Следующее
От: Paul Branston
Дата:
Сообщение: Re: [GENERAL] multiple users