[SQL] Indexing question

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

Re: [SQL] [GENERAL] Indexing question

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of amit sehas Sent: Tuesday, August 14, 2012 12:55 PM To: pgsql-sql@postgresql.org; pgsql-gene...@postgresql.org Subject: [GENERAL] Indexing question In SQL, given a