Re: md5 function

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
>
> where is problem???

I'm using 7.4 and it's working.
$ psql
Welcome to psql 7.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

db=# select md5('test');
md5
----------------------------------
098f6bcd4621d373cade4e832627b4f6
(1 row)