btober(at)computer(dot)org wrote:
>>Dias Bantekas wrote:
>>
>>
>>>does any one know how to get an md5()-like hash function using
>>>pgcrypto for postgresql 7.3 ? without upgrading to 7.4
>>>
>>>Thanks for any input.
>>
>>SELECT encode(digest(v_password, 'md5'), 'hex');
>
>
> BTW,
>
> /usr/share/pgsql/contrib/pgcrypto.sql
>
> is the script that defines the encode and digest functions.
>
> --Berend Tober
>
>
>
>
thanks hlk, that's exactly what I was looking for.
Now I can create a md5() function and do my job!
encode is a native PG string function, it is not defined in pgcrypto.
Dias