pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedNew Type
2+ messages / 2 participants
[nested] [flat]
* New Type
@ 2000-05-26 20:03 Olivier PRENANT <ohp@pyrenet.fr>
2000-05-27 07:22 ` Re: New Type selkovjr@mcs.anl.gov
0 siblings, 1 reply; 2+ messages in thread
From: Olivier PRENANT @ 2000-05-26 20:03 UTC (permalink / raw)
To: pgsql-hackers@posgresql.org; +Cc: 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???
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)
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: New Type
2000-05-26 20:03 New Type Olivier PRENANT <ohp@pyrenet.fr>
@ 2000-05-27 07:22 ` selkovjr@mcs.anl.gov
0 siblings, 0 replies; 2+ messages in thread
From: selkovjr@mcs.anl.gov @ 2000-05-27 07:22 UTC (permalink / raw)
To: ohp@pyrenet.fr; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-05-27 07:22 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-26 20:03 New Type Olivier PRENANT <ohp@pyrenet.fr>
2000-05-27 07:22 ` selkovjr@mcs.anl.gov
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox