Re: select md5 result set

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wed, Aug 2, 2017 at 3:42 PM, Peter Koukoulis <pkoukoulis@xxxxxxxxx> wrote:

SQL> select dbms_sqlhash.gethash('select x,y from test1',2) as md5_value from dual;

MD5_VALUE

--------------------------------------------------------------------------------

9FDA7FA725B783172CA371DA04AD5754

Can I do something similar in PostgreSQL ?

​Similar.​

 SELECT md5(string_agg(vals::text, ''))

 FROM ( VALUES (1, 2), (2, 3) ) vals (x, y)

​David J.