Re: Indexing for Expression type data using GIST

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Wizard Shah <wizardshah(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Indexing for Expression type data using GIST
Date: 2008-03-27 19:34:04
Message-ID: 20080327193404.GA15848@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 27, 2008 at 02:03:09PM -0500, Wizard Shah wrote:
> Hi All,
>
> I am trying to implement indexing mechanism for the Expression type
> data using GIST. For that purpose I need to store some extra
> information in the Meta-Data of the GIST Index.

There is no real provision for this but, depending on what it is there
may be other options. For example perhaps you can use the typmod or
something like that.

> The information is entered when the index is created on the table.
> Can any body give me some suggestion how to do that. I'll be really
> grateful.

If you provide some more information about what the information
represents we might be able to give you a better idea.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-03-27 19:35:11 Re: psql and named pipes
Previous Message Wizard Shah 2008-03-27 19:03:09 Indexing for Expression type data using GIST