RE: Indexing varchar[]'s

I meant:

create table test(fld1 varchar(20)[])

can't index that.  :(

eric


> -----Original Message-----
> From: Tim Barnard [mailto:tbarnard@povn.com]
> Sent: Friday, June 15, 2001 10:04 AM
> To: Eric Ridge
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] 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
> >
>
>