From: Lance Jacob <JacobLJ@familysearch.org>
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: 'bitwise and' index
Thread-Topic: 'bitwise and' index
Thread-Index: AQHQYzMqPH23QFZgrU6dUEfk6EmL3Q==
Date: Fri, 20 Mar 2015 17:27:40 +0000
Message-ID: <D131B4AA.6F24%jacoblj@familysearch.org>
Accept-Language: en-US
Content-Language: en-US
user-agent: Microsoft-MacOutlook/14.4.8.150116
Content-Type: multipart/alternative;
 boundary="_000_D131B4AA6F24jacobljfamilysearchorg_"
MIME-Version: 1.0
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

--_000_D131B4AA6F24jacobljfamilysearchorg_
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="Windows-1252"

I have an Oracle database that I migrated to Postgres.  I=92ve been success=
ful with everything except the creation of one index.  On the oracle side t=
he index was created with the syntax =93create index abc on xyz (bitand(col=
umn_name,16384))=94.  What would be the proper syntax for creating a simila=
r 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 al=
l copies of the original message.


--_000_D131B4AA6F24jacobljfamilysearchorg_
Content-ID: <FE88750C4DC97C4AADB0C295A1138833@ldschurch.org>
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="Windows-1252"

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
</head>
<body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-lin=
e-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-fami=
ly: Calibri, sans-serif;">
<div>I have an Oracle database that I migrated to Postgres. &nbsp;I=92ve be=
en successful with everything except the creation of one index. &nbsp;On th=
e oracle side the index was created with the syntax =93create index abc on =
xyz (bitand(column_name,16384))=94. &nbsp;What would
 be the proper syntax for creating a similar bitwise function-based index i=
n Postgres? &nbsp;Or, is it even possible?</div>
<div><br>
</div>
<div>LanceJacob</div>
<br>

<DIV>
<p class=3DMsoNormal><span style=3D&#39;font-size:7.0pt&#39;;font-family:&#=
39;"Helvetica","Tahoma","Arial","sans-serif"&#39;><font color=3D"#666666"><=
br><br> NOTICE: This email message is for the sole use of the intended reci=
pient(s) and may contain confidential and privileged information. Any unaut=
horized review, use, disclosure or distribution is prohibited. If you are n=
ot the intended recipient, please contact the sender by reply email and des=
troy all copies of the original message.</span><o:p></o:p></span></p><BR>
</DIV></body>
</html>

--_000_D131B4AA6F24jacobljfamilysearchorg_--