RE: New Type - Mailing list pgsql-hackers

From Krotenko Valery V.
Subject RE: New Type
Date
Msg-id 8134443A7FD1D211A33900104BB51A8A7659@bigstar.etr.ru
Whole thread Raw
In response to New Type  (Olivier PRENANT <ohp@pyrenet.fr>)
List pgsql-hackers
>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
I have function for crypt password in MD5(c - function). Are you
need it.
Valery Krotenko. 




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Mention WAL in the book
Next
From: Bruce Momjian
Date:
Subject: secondary password files