Indexes on Arrays - Mailing list pgsql-hackers

From Kristofer Munn
Subject Indexes on Arrays
Date
Msg-id Pine.LNX.4.10.10009051335020.6691-100000@munn.com
Whole thread Raw
Responses Re: Indexes on Arrays
List pgsql-hackers
Hello everyone.  Hopefully someone can give me an answer and workaround on
this...

I have a table with an array like so:
create table foo (    id    int4,    names    varchar(80)[]);

and would like to place an index on name[1].  I try
create table foo_idx1 on foo (names[1]);

but I get...
ERROR:  parser: parse error at or near "["

Thoughts and suggestions are welcome.

- K

Kristofer Munn * KMI * 732-254-9305 * AIM KrMunn * http://www.munn.com/




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: RPMs and symlinks (was Re: [NOVICE] C++ library probs)
Next
From: Mario Weilguni
Date:
Subject: Crash on userdefined operator