and
without an index.
---
Grace
- Original Message -
From: "Greg Stark" <[EMAIL PROTECTED]>
To: "Grace C. Unson" <[EMAIL PROTECTED]>
Cc: "PgSQL SQL" <[EMAIL PROTECTED]>
Sent: Sunday, December 07, 2003 8:36 AM
Subject: Re: [SQL] Index not re
"Grace C. Unson" <[EMAIL PROTECTED]> writes:
> 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 (text
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 na
