Re: [HACKERS] Solution to the pg_user passwd problem !?? (c)

> >
> > > ------- OTHER WISE ---- CAN WE STEAL IDEAS FROM OTHERS? --------
> > >
> > > I'm also running MySQL (trying to switch to PG, but waiting for ODBC
> > > to catch up), I like the mysql feature of inserting passords by:
> > >
> > >     insert into user (host,user,password)
> > >     values ("domain.com","dlorenso",password('psswrd');
> >
> > Hmmm... When I read this, another (related) idea pops into my head.
> > It's probably nothing, but:
> >
> > what about defining a new type 'passwd', with
> > an input (or output) routine which does the crypting?
>
> If they do a binary cursor, does the output function get called?

Oops, I haven't thought about that. I guess it doesn't :(
Ok, what about an input routine that does the crypting?

One down, one to go...

Cheers,
Ronald