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.
