From: | Choosna Makarasara <choosna(at)rajavithi(dot)go(dot)th> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | create index with user-defined function |
Date: | 2000-08-18 01:40:48 |
Message-ID: | 399C9420.978A07DE@rajavithi.go.th |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-08-18 01:45:18 | Re: create index with user-defined function |
Previous Message | Andrew Snow | 2000-08-18 00:08:51 | RE: OID decreasing? |