From: Lance Jacob <JacobLJ@familysearch.org>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: 'bitwise and' index
Date: Fri, 20 Mar 2015 17:27:40 +0000
Message-ID: <D131B4AA.6F24%jacoblj@familysearch.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
I have an Oracle database that I migrated to Postgres. I’ve been successful with everything except the creation of one index. On the oracle side the index was created with the syntax “create index abc on xyz (bitand(column_name,16384))”. What would be the proper syntax for creating a similar bitwise function-based index in Postgres? Or, is it even possible?
LanceJacob
NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
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: JacobLJ@familysearch.org
Subject: Re: 'bitwise and' index
In-Reply-To: <D131B4AA.6F24%jacoblj@familysearch.org>
* 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