X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ED45B3A642B for ; Sat, 11 Dec 2004 18:59:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12760-10 for ; Sat, 11 Dec 2004 18:59:03 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 2E8123A6411 for ; Sat, 11 Dec 2004 18:59:02 +0000 (GMT) Received: (qmail 2386 invoked by uid 500); 11 Dec 2004 19:11:36 -0000 Date: Sat, 11 Dec 2004 13:11:36 -0600 From: Bruno Wolff III To: Joe Conway Cc: =?iso-8859-1?Q?M=AA_Jos=E9?= Sempere , pgsql-admin@postgresql.org Subject: Re: pgcrypto module for WINDOWS Message-ID: <20041211191136.GC1613@wolff.to> Mail-Followup-To: Joe Conway , =?iso-8859-1?Q?M=AA_Jos=E9?= Sempere , pgsql-admin@postgresql.org References: <000501c4de9f$b3c90ac0$0900a8c0@mj> <41BA8222.8000409@joeconway.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <41BA8222.8000409@joeconway.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/101 X-Sequence-Number: 15687 On Fri, Dec 10, 2004 at 21:14:10 -0800, Joe Conway 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.