Re: MD5 in pg and php

> Thanks, I already found some fc1 rpm's (still in development). But can
> anyone tell me if the 7.4 internal md5() function will do the same as
> the PHP md5() function? Or do a quick select md5('apple') and let me
> know if the result is 'ae6d32585ecc4d33cb8cd68a047d8434'?
>
> I really wouldn't like to upgrade from my current stable situation,
> only to find out that it didn't solve my original problem.

Postgres 7.4:

usa=> select md5('apple');
md5
----------------------------------
1f3870be274f6c49b3e31a0c6728957f
(1 row)

And my PHP:

bash-2.05a$ php -q
<?php echo md5('apple') ?>
1f3870be274f6c49b3e31a0c6728957f

So mine are the same, but yours is completely different to anything.

Chris