Re: select md5 result set

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(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Wed, Aug 2, 2017 at 3:42 PM, Peter Koukoulis <pkoukoulis(at)gmail(dot)com>
> 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.
>
>