From: | ohp(at)pyrenet(dot)fr |
---|---|
To: | pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
Subject: | GiST future |
Date: | 2004-04-02 14:17:35 |
Message-ID: | Pine.UW2.4.53.0404021610170.29667@server.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi every one.
I've played a bit with contrib/intarray and very much liked being able to
index a whole array.
Now I wonder why 7.4 array queries using SOME/ANY/ALL don't make use of
this king of indexes.
Is there any plan to integrate Oleg's job into the core as GiST indexes
were?
it would be nice to generalize things like
SELECT col1 from table where col2 contains (select col3 from table2 where
...) and use those indexes.
Or did I miss something in the docs?
What does core team think?
Best regards
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-04-02 14:40:41 | Re: Inconsistent behavior on Array & Is Null? |
Previous Message | Greg Stark | 2004-04-02 08:22:41 | Re: Inconsistent behavior on Array & Is Null? |