Re: md5(bytea)

Abhijit Menon-Sen <ams(at)oryx(dot)com> writes:
> At 2005-05-18 23:31:27 -0400, tgl(at)sss(dot)pgh(dot)pa(dot)us wrote:
>> Doesn't that change cause the opr_sanity regression test to complain?

> As far as I can tell, updating the test as below is the correct thing
> to do.

No, I don't much care for that, because it gives free license for anyone
to define pg_proc entries that allow bytea values to be fed to functions
that are expecting text inputs. Many of the latter are not going to
cope very well with strings that contain embedded zero bytes, nor byte
sequences that aren't legal multibyte characters in the current encoding.

I think you need to make a separate C-level function for this. The
underlying md5 code might be the same, but text and bytea are not really
binary-equivalent.

regards, tom lane