Received: from magus.postgresql.org ([87.238.57.229])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <cun23@yahoo.com>) id 1T1KON-0004oN-FP
	for pgsql-general@postgresql.org; Tue, 14 Aug 2012 16:54:55 +0000
Received: from nm25-vm2.bullet.mail.ne1.yahoo.com ([98.138.91.213])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <cun23@yahoo.com>) id 1T1KOJ-00023T-Hk
	for pgsql-general@postgresql.org; Tue, 14 Aug 2012 16:54:55 +0000
Received: from [98.138.90.55] by nm25.bullet.mail.ne1.yahoo.com with NNFMP;
	14 Aug 2012 16:54:49 -0000
Received: from [98.138.89.170] by tm8.bullet.mail.ne1.yahoo.com with NNFMP;
	14 Aug 2012 16:54:49 -0000
Received: from [127.0.0.1] by omp1026.mail.ne1.yahoo.com with NNFMP;
	14 Aug 2012 16:54:49 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 501459.75312.bm@omp1026.mail.ne1.yahoo.com
Received: (qmail 28080 invoked by uid 60001); 14 Aug 2012 16:54:49 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1344963289; bh=xB1Ywme8d6kcRnSNBTstdrtGn1wdLl3PocfSVnaKYFs=;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type;
	b=ZzjPlJPgrj5eWwQ3WSMoIlo/jo5EBW2b+jbMx8PN1oBJO1AumFmiBCOAcUECEV8aU10I2x97esbScwzU3SJ9Gd4541qw9/DWpNHyUAijACa1Vx0vFhbL+GIzyY52OWRPFb9xZV90XtC2ms1C2/voiV56J7e1IQ91wPgVFrwMHxE=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:MIME-Version:Content-Type;
	b=4MrDz+0SbscHuIGzhJN/06BPa56DuZ7UktG08MS5SV6G542RHB3158+v8EX1Zn+67zxP1jG+NoQwT6pdB08mt2DDz9qnYTSqlaqSD4bBDEUPn0mx/g88VTxa/eVzwQic36QgefjzHEWLrMgx/+4LmCM828DFpt2C2fROvhlzrQQ=;
X-YMail-OSG: ATN0mokVM1kV564UJx2zCfaaYt0fmJPcGI2C7_.8DlKA1W1
	AzV6Xa5FH6mNxSax0r67VTLTXMfAn7Z71tNxjlJNFB3zBlcsS_Mb0IzSKrjv
	fIh2AFeb5CsG_ntQqDwp_Mvucwogwuv.n0SBuYdRJ8dqXz9fDd8vQa2PxY3s
	6mcS09pf_tRerGem1.iets8DWQ5.YjK7NCkzHT1wDlgFeK7gllb1KJL50dVx
	ufKx25xnEr_bODnjwYNJw8G0O5lGkak1laKfET_7CGohw54rG.y6z7DVZ_tA
	QCb9pcaD3_Vn21LM0c.Ctkc8ic0J2hvz5RiJFEBSEE7CwIdzkRTOswKNJlPM
	TKD_TjdPFZf2seGORvNkOB5rOVn6GQWhH3clA7TFs6BPC3WCDIEUCE1CWkys
	fZD2MZbSSSDln.pfFzivrcoL6dicuPxPtLdLBO2LgleRYrhV0i6XK6Ar1ic5
	Kp9XqG_cMJA--
Received: from [107.1.81.2] by web125305.mail.ne1.yahoo.com via HTTP;
	Tue, 14 Aug 2012 09:54:48 PDT
X-Mailer: YahooMailClassic/15.0.8 YahooMailWebService/0.8.120.356233
Message-ID: <1344963288.3544.YahooMailClassic@web125305.mail.ne1.yahoo.com>
Date: Tue, 14 Aug 2012 09:54:48 -0700 (PDT)
From: amit sehas <cun23@yahoo.com>
Subject: Indexing question
To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Pg-Spam-Score: 0.9 (/)
X-Archive-Number: 201208/284
X-Sequence-Number: 189461

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, 

any advice is greatly appreciated ..

thanks