Index not recognized

Поиск
Список
Период
Сортировка
От Grace C. Unson
Тема Index not recognized
Дата
Msg-id 001101c3bbb6$8b0db840$ec64a8c0@GREECE
обсуждение исходный текст
Ответ на Is it possible to set a NOT NULL constraint deferrable?  (Olivier Hubaut <olivier@scmbb.ulb.ac.be>)
Ответы Re: Index not recognized  (Greg Stark <gsstark@mit.edu>)
Список 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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Olivier Hubaut
Дата:
Сообщение: Is it possible to set a NOT NULL constraint deferrable?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: What's wrong with COPY rights in 7.3.4?