Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: [GENERAL] select md5 result set
Date
Msg-id CAKFQuwYeByHPnK3wUHv_-yBqf9uZ6TuJHMb9pPR9gnstsRV6pA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] select md5 result set  (Peter Koukoulis <pkoukoulis@gmail.com>)
Responses Re: [GENERAL] select md5 result set  (Peter Koukoulis <pkoukoulis@gmail.com>)
Re: [GENERAL] select md5 result set  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Tree view
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: Peter Koukoulis
Date:
Subject: [GENERAL] select md5 result set
Next
From: Peter Koukoulis
Date:
Subject: Re: [GENERAL] select md5 result set