| From: | Lance Jacob <JacobLJ(at)familysearch(dot)org> |
|---|---|
| To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | 'bitwise and' index |
| Date: | 2015-03-20 17:27:40 |
| Message-ID: | D131B4AA.6F24%jacoblj@familysearch.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Neyman | 2015-03-20 17:33:22 | Re: 'bitwise and' index |
| Previous Message | agharta | 2015-03-20 07:31:07 | Re: Detect which sum of cartesian product (+ any combination of n records in tables) exceeds a value |