| From: | Kristofer Munn <kmunn(at)munn(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Indexes on Arrays |
| Date: | 2000-09-05 17:39:20 |
| Message-ID: | Pine.LNX.4.10.10009051335020.6691-100000@munn.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Wolfe | 2000-09-05 17:42:09 | Re: Report of performance on Alpha vs. Intel |
| Previous Message | Mitch Vincent | 2000-09-05 17:35:57 | Re: Report of performance on Alpha vs. Intel |