Re: Is it possible to create an index without keeping the indexed data in a column?

Amit Langote wrote
> On Fri, Aug 1, 2014 at 2:50 PM, Amit Langote <

> amitlangote09@

> > wrote:
>>
>> Not sure exactly if it applies here;
>
> Re-reading the OP again, perhaps it doesn't. Sorry about the noise

This is a functional index which lets you store derived data in the index
without having to also store it in the table.  Mostly useful for stuff that
is only relevant in the context of searching and not something you would
ever return to the user.

The restriction here is that the raw data still needs to be stored in the
table.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Is-it-possible-to-create-an-index-without-keeping-the-indexed-data-in-a-column-tp5813461p5813499.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.