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.johns...@gmail.com>
wrote:
> On Wed, Aug 2, 2017 at 3:42 PM, Peter Koukoulis <pkoukou...@gmail.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.
>
>
