Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] select md5 result set - Mailing list pgsql-general

From Peter Koukoulis
Subject Re: [GENERAL] select md5 result set
Date
Msg-id CABpxA9iyKqjvqEyAkxhUB56VSuS1AMubtdMmgyqaLMhyx61HtA@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] select md5 result set  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [GENERAL] select md5 result set  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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@gmail.com> wrote:
On Wed, Aug 2, 2017 at 3:42 PM, Peter Koukoulis <pkoukoulis@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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] select md5 result set
Next
From: Alex Samad
Date:
Subject: Re: [GENERAL] Question about loading up a table