From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-general@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Re: Indexing question
Date: Tue, 14 Aug 2012 19:33:38 +0200
Message-ID: <20120814173338.GA15693@tux> (raw)
In-Reply-To: <1344963288.3544.YahooMailClassic@web125305.mail.ne1.yahoo.com>
References: <1344963288.3544.YahooMailClassic@web125305.mail.ne1.yahoo.com>
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°
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: akretschmer@spamfence.net, pgsql-general@postgresql.org
Subject: Re: Indexing question
In-Reply-To: <20120814173338.GA15693@tux>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox