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@tcdi.com>
To: <pgsql-general@postgresql.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@postgresql.org
>