create index with user-defined function
| От | Choosna Makarasara |
|---|---|
| Тема | create index with user-defined function |
| Дата | |
| Msg-id | 399C9420.978A07DE@rajavithi.go.th обсуждение исходный текст |
| Ответы |
Re: create index with user-defined function
|
| Список | pgsql-general |
Dear all, I sent this message� a few days ago without response so I post it again in case someone may help me. I use PostgreSQL 6.5 and create a function� tmod(bpchar) written in C. When I try to create index using the function I have the following problem. ------ 1------- mydb=> CREATE INDEX vi_id ON village (vi_name bpchar_ops,vi_id bpchar_ops); CREATE this works find. ------ 2 ------- mydb=> CREATE INDEX tmodvi_name ON village (TMOD(vi_name) bpchar_ops); CREATE this also works fine. but when I try ------ 3 ------- mydb=> CREATE INDEX xxvi_name ON village (TMOD(vi_name) bpchar_ops,vi_id bpchar_ops); ERROR:� parser: parse error at or near "," What wrong with this?� Can I create index� multiple column index with user-defined function?? Choosna Makarasara � � �
В списке pgsql-general по дате отправления: