pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
'bitwise and' index 2+ messages / 2 participants [nested] [flat]
* 'bitwise and' index @ 2015-03-20 17:27 Lance Jacob <JacobLJ@familysearch.org> 2015-03-20 17:33 ` Re: 'bitwise and' index Igor Neyman <ineyman@perceptron.com> 0 siblings, 1 reply; 2+ messages in thread From: Lance Jacob @ 2015-03-20 17:27 UTC (permalink / raw) To: 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 'bitwise and' index 2015-03-20 17:27 'bitwise and' index Lance Jacob <JacobLJ@familysearch.org> @ 2015-03-20 17:33 ` Igor Neyman <ineyman@perceptron.com> 0 siblings, 0 replies; 2+ messages in thread From: Igor Neyman @ 2015-03-20 17:33 UTC (permalink / raw) To: Lance Jacob <JacobLJ@familysearch.org>; pgsql-sql From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Lance Jacob Sent: Friday, March 20, 2015 1:28 PM To: pgsql-sql@postgresql.org Subject: [SQL] 'bitwise and' index 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 Try: create index abc on xyz (column_name & 16384); Regards, Igor Neyman ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-03-20 17:33 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2015-03-20 17:27 'bitwise and' index Lance Jacob <JacobLJ@familysearch.org> 2015-03-20 17:33 ` Igor Neyman <ineyman@perceptron.com>
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