Re: Why the index is not used ?
| От | Paul McGarry |
|---|---|
| Тема | Re: Why the index is not used ? |
| Дата | |
| Msg-id | AFD3D125-FAED-42A8-B475-4A8FD568775B@paulmcgarry.com обсуждение исходный текст |
| Ответ на | Why the index is not used ? (ROS Didier <didier.ros@edf.fr>) |
| Ответы |
RE: Why the index is not used ?
RE: Why the index is not used ? RE: Why the index is not used ? |
| Список | pgsql-sql |
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
WHERE cc=pgp_sym_encrypt('test value 32', 'motdepasse');
В списке pgsql-sql по дате отправления: