On Fri, Dec 10, 2004 at 21:14:10 -0800,
Joe Conway <mail(at)joeconway(dot)com> wrote:
> Mª José Sempere wrote:
> >We are interested in installing the pgcrypto module of PostgreSQL for
> > Windows, In order to use the function digest() for creating index on
> >bytea type fields:
> >
> >create unique index my_index on my_table (digest(my_bytea_field,
> >'md5'));
>
>
> Um, why would you want to use digest() just so that you can index a
> bytea field?
They might be using M5 hashes as external names for the entries.