Received: from server.pyrenet.fr (server.pyrenet.fr [194.250.190.1]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA55357 for ; Fri, 26 May 2000 16:03:58 -0400 (EDT) (envelope-from ohp@pyrenet.fr) Received: from localhost (localhost [127.0.0.1]) by server.pyrenet.fr (8.9.3/8.9.3) with ESMTP id WAA04151; Fri, 26 May 2000 22:03:56 +0200 (MET DST) Date: Fri, 26 May 2000 22:03:56 +0200 (MET DST) From: Olivier PRENANT Reply-To: ohp@pyrenet.fr To: pgsql-hackers@posgresql.org cc: pgsql-sql@postgresql.org Subject: New Type Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200005/169 Hi all, I'm trying to create a type password; the goal is to have a table like: CREATE TABLE test ( username varchar, pass passwd); insert into test values ('me','secret'); and have "secret" being automagicly crypted. What I want is to mimic the PASSWORD function of mysql but much better, not having to call a function. I just can't figure how to write the xx_crypt(opaque) returns opaque function. Any help available??? TIA -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)