Re: select md5 result set

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Peter Koukoulis <pkoukoulis(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: select md5 result set
Date: 2017-08-02 23:25:40
Message-ID: CAKFQuwYeByHPnK3wUHv_-yBqf9uZ6TuJHMb9pPR9gnstsRV6pA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Koukoulis 2017-08-02 23:50:13 Re: select md5 result set
Previous Message Peter Koukoulis 2017-08-02 22:42:16 select md5 result set