Re: [GENERAL] md5 function

[Marek Lewczuk]

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)


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org