From: | Choosna Makarasara <choosna(at)rajavithi(dot)go(dot)th> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | index with user-defined function |
Date: | 2000-08-16 05:52:05 |
Message-ID: | 399A2C05.29539C9E@rajavithi.go.th |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear all,
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 using multiple rows with
user-defined function??
Choosna Makarasara
From | Date | Subject | |
---|---|---|---|
Next Message | John Morton | 2000-08-16 06:44:27 | Unimpletmented features |
Previous Message | sridhvenk | 2000-08-16 05:36:44 | Re: Tables Question |