Index not recognized

From: "Grace C(dot) Unson" <gracec(at)ntsp(dot)nec(dot)co(dot)jp>
To: "PgSQL SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: Index not recognized
Date: 2003-12-06 05:05:18
Message-ID: 001101c3bbb6$8b0db840$ec64a8c0@GREECE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello.

Why is it that my index for text[] data type is not recognized by the
Planner?

I did these steps:

1. create function textarr(text[]) returns text language sql as 'select
$1[1]' strict immutable
2. create index org_idx on EmpData (textarr(org));

3. vacuum full
4. explain analyze select name from EmpData where org *= 'math';

Result:
=========
Seq Scan on EmpData (cost=0.00..3193.20 rows=102 width=488)
(actual time=3.71.35..371.35 rows=0 loops=1)

Filter: (org[0]='math'::text)

Total runtime: 371.47 msec
(3 rows)

==========

I have 20,496 records. My postgres version is 7.3.

Any help is greatly appreciated.

Thank you..

Ace

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2003-12-06 12:27:26 Re: What's wrong with COPY rights in 7.3.4?
Previous Message David Shadovitz 2003-12-05 21:51:20 Fetch a single record