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/