Thread

1. New Type

   Olivier PRENANT <ohp@pyrenet.fr> — 2000-05-26T20:03:56Z

   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)
   
   
   

2. Re: New Type

   selkovjr@mcs.anl.gov — 2000-05-27T07:22:32Z

   > 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???
   
   Yes. Send me your code as a function that runs in a.out, I will
   convert it. You will get in a form suitable for use as a contrib. You
   will then be on your own. I'll do it in a split-second, but give me a
   day or two to respond; I am moving and can't read my mail often enough.
   
   --Gene