Re: Indexing varchar[]'s

I'm running 7.1.2 and have no problem doing so.

ca=#create table test(fld1 varchar(20));
CREATE
ca=#create index test_pkey on test (fld1);
CREATE

Tim

----- Original Message -----
From: "Eric Ridge" <ebr(at)tcdi(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, June 14, 2001 4:59 PM
Subject: [GENERAL] Indexing varchar[]'s

> If this has been asked and answered before, I am sorry. I've been
> digging through the mail archives and cannot find this particular
> question (although some releated to int64[]'s). Is it possible, with
> 7.1.2, to create an index on a varchar[]?
>
> I've tried:
> # create index foo on mytable (myfield);
> ERROR: DefineIndex: type _varchar has no default operator class
> and
> # create index foo on mytable (myfield varchar_ops);
> ERROR: DefineIndex: opclass "varchar_ops" does not accept datatype
> "_varchar"
> and
> # create index foo on docket (case_name[1]);
> ERROR: parser: parse error at or near "["
>
>
> Am I missing something obvious, or can it just not be done right now?
>
> If it's not possible right now, is it in the works? If not, could
> someone point me in the right direction for creating operator classes,
> or briefly outline what would be necessary to do this?
>
> I'm new to postgres and have just starting looking seriously at the
> sources.
>
> thanks in advance.
>
> eric
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>