GiST future

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)

Responses

Browse pgsql-hackers by date

  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?