Re: md5 function

On Wed, Dec 17, 2003 at 09:37:07AM +0000, Richard Huxton wrote:
> On Wednesday 17 December 2003 08:47, Miso Hlavac wrote:
> > Hello,
> >
> > Sorry for just stupid question, but I need use md5 function in 7.4
> > When I write:
> > select md5('text');
> > ERROR:  Function md5("unknown") does not exist
> >         Unable to identify a function that satisfies the given argument
> > types You may need to add explicit typecasts
>
> Have a look in the contrib/crypto add-on, I think md5() is in there.

md5() should be stock in 7.4.

mydb=> \x
Expanded display is on.
mydb=> \df+ md5
List of functions
-[ RECORD 1 ]-------+--------------------
Result data type    | text
Schema              | pg_catalog
Name                | md5
Argument data types | text
Owner               | pgsql
Language            | internal
Source code         | md5_text
Description         | calculates md5 hash

The internal function md5_text() is in src/backend/utils/adt/varlena.c.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/