X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 141A9D1B474 for ; Sat, 6 Dec 2003 05:06:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95379-04 for ; Sat, 6 Dec 2003 01:05:34 -0400 (AST) Received: from TYO202.gate.nec.co.jp (TYO202.gate.nec.co.jp [210.143.35.52]) by svr1.postgresql.org (Postfix) with ESMTP id 9AEA0D1B459 for ; Sat, 6 Dec 2003 01:05:32 -0400 (AST) Received: from mailgate4.nec.co.jp (mailgate54.nec.co.jp [10.7.69.193]) by TYO202.gate.nec.co.jp (8.11.7/3.7W01080315) with ESMTP id hB655UM26853 for ; Sat, 6 Dec 2003 14:05:30 +0900 (JST) Received: (from root@localhost) by mailgate4.nec.co.jp (8.11.7/3.7W-MAILGATE-NEC) id hB655UF03126 for pgsql-sql@postgresql.org; Sat, 6 Dec 2003 14:05:30 +0900 (JST) Received: from fireball.ntsp.nec.co.jp (postfix@[172.28.58.1]) by isgw1.nec.co.jp (8.11.7/3.7W-ISGW-NEC) with ESMTP id hB655T512086 for ; Sat, 6 Dec 2003 14:05:29 +0900 (JST) Received: from the-one (localhost [127.0.0.1]) by fireball.ntsp.nec.co.jp (Postfix) with ESMTP id 3724B29B0D for ; Sat, 6 Dec 2003 13:02:39 +0800 (HKT) Received: from 172.28.58.4 ([172.28.58.4] helo=galadriel.ntsp.nec.co.jp) by the-one ; 6 Dec 03 05:02:39 -0000 Received: from hq.ntsp.nec.co.jp (frytrix.hq.ntsp.nec.co.jp [172.28.58.129]) by galadriel.ntsp.nec.co.jp (Postfix) with ESMTP id 473EF40232 for ; Sat, 6 Dec 2003 13:04:06 +0800 (PHT) Received: (from smtp@localhost) by hq.ntsp.nec.co.jp (8.9.2/8.9.2) id MAA26376 for ; Sat, 6 Dec 2003 12:44:32 +0800 (HKT) Received: from UNKNOWN(192.168.100.236), claiming to be "GREECE" via SMTP by frytrix, id smtpdAAA0Y6lfh; Sat Dec 6 04:44:26 2003 Message-ID: <001101c3bbb6$8b0db840$ec64a8c0@GREECE> From: "Grace C. Unson" To: "PgSQL SQL" References: <3FD0A87B.4010803@scmbb.ulb.ac.be> Subject: Index not recognized Date: Sat, 6 Dec 2003 13:05:18 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=REFERENCES X-Spam-Level: X-Archive-Number: 200312/51 X-Sequence-Number: 16217 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