Re: New Type

From: selkovjr(at)mcs(dot)anl(dot)gov
To: ohp(at)pyrenet(dot)fr
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: New Type
Date: 2000-05-27 07:22:32
Message-ID: 200005270722.CAA03709@mail.xnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql


> 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

In response to

  • New Type at 2000-05-26 20:03:56 from Olivier PRENANT

Browse pgsql-hackers by date

  From Date Subject
Next Message Gunnar R|nning 2000-05-27 09:30:27 Re: Postgresql 7.0 JDBC exceptions - broken connections ?
Previous Message Tom Lane 2000-05-27 06:06:00 Re: Rename pl/tcl to pl/pltcl

Browse pgsql-sql by date

  From Date Subject
Next Message CB 2000-05-27 10:29:35 joins again
Previous Message Tom Lane 2000-05-27 04:06:54 Re: Re: [SQL] aliases break my query