RE: New Type

From: "Krotenko Valery V(dot)" <vitas(at)Etr(dot)ru>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: New Type
Date: 2000-05-30 19:38:11
Message-ID: 8134443A7FD1D211A33900104BB51A8A7659@bigstar.etr.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-05-30 19:42:57 secondary password files
Previous Message Hannu Krosing 2000-05-30 19:03:22 Re: Applying TOAST to CURRENT