Re: [GENERAL] aggregate hash function

2008-01-30 Thread Matthew Dennis
On Jan 30, 2008 4:40 PM, Vyacheslav Kalinin <[EMAIL PROTECTED]> wrote: > Most implementations of md5 internally consist of 3 functions: md5_init - > which initializes internal context, md5_update - which accepts portions of > data and processes them and md5_final - which finalizes the hash and > r

Re: [GENERAL] aggregate hash function

2008-01-30 Thread Vyacheslav Kalinin
Most implementations of md5 internally consist of 3 functions: md5_init - which initializes internal context, md5_update - which accepts portions of data and processes them and md5_final - which finalizes the hash and releases the context. These roughly suit aggregate's internal functions (SFUNC

[GENERAL] aggregate hash function

2008-01-30 Thread Matthew Dennis
I'm in need of an aggregate hash function. Something like "select md5_agg(someTextColumn) from (select someTextColumn from someTable order by someOrderingColumn)". I know that there is an existing MD5 function, but it is not an aggregate. I have thought about writing a "concat" aggregate functio