Re: select md5 result set

[Peter Koukoulis <pkoukoulis@xxxxxxxxx>]

david, thanks for the help.

Would this be the equivalent, for the statement in your email, for table TEST1 (x integer, y varchar(20)):

ft_node=# SELECT md5(string_agg(vals::text, ''))

ft_node-# from (select x,y from test1) vals(x,y);

?

Peter

On Thu, 3 Aug 2017 at 00:25 David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

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.