On Fri, Dec 10, 2004 at 21:14:10 -0800, Joe Conway <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster