Re: Why the index is not used ?
Paul McGarry <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.sql,gmane.comp.db.postgresql.performance,gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
I haven’t looked up what pgp_sym_encrypt() does but assuming it does encryption the way you should be for credit card data then it will be using a random salt and the same input value won’t encrypt to the same output value so
====
WHERE cc=pgp_sym_encrypt('test value 32', 'motdepasse');
====
wouldn’t work because the value generated by the function when you are searching on isn’t the same value as when you stored it.
Paul
> On 6 Oct 2018, at 19:57, ROS Didier <[email protected]> wrote:
>
> WHERE cc=pgp_sym_encrypt('test value 32', 'motdepasse');