index with user-defined function

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

Browse pgsql-general by date

  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