[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] [GENERAL] Indexing question
From:       Andreas Kretschmer <akretschmer () spamfence ! net>
Date:       2012-08-14 17:33:38
Message-ID: 20120814173338.GA15693 () tux
[Download RAW message or body]

amit sehas <cun23@yahoo.com> wrote:

> In SQL, given a table T, with two fields f1, f2, 
> 
> is it possible to create an index such that the same record is indexed
> in the index, once with field f1 and once with field f2.  (I am not
> looking for a compound index in which the key would look like <f1,
> f2>, instead there should be two entries in the index <f1> and <f2>).  
> 
> we have a few use cases for the above, perhaps we need to alter the
> schema somehow to accommodate the above, 

2 separate indexes? One on f1 and one on f2?


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
[prev in list] [next in list] [prev in thread] [next in thread]