Re: [SQL] [GENERAL] Indexing question

2012-08-15 Thread David Johnston
> -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, g

Re: [SQL] [GENERAL] Indexing question

2012-08-14 Thread Andreas Kretschmer
amit sehas 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 f2>, instead the