Re: select md5 result set

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

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

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);

?

​The subquery is redundant if you already have a table:

select md5(string_agg(test1::text, '')) from test1;

David J.​