select md5 result set

From: Peter Koukoulis <pkoukoulis(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: select md5 result set
Date: 2017-08-02 22:42:16
Message-ID: CABpxA9hX3m8X2w9dyZyhxXcRMStXo1BspGbVCWegk=te0Es8vA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I'm attempting to emulate feature available in Oracle, namely dbs_sqlhash.
For example, given the following table data values:

SQL> select x,y from test1;

X Y
---------- --------------------
5 White
1 YYY
2 Goodbye
6 Black

I can create a single hash value over the entire result set, specifically
md5, in a query as follows:

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 ?

Thanks
P

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-08-02 23:25:40 Re: select md5 result set
Previous Message Tom Lane 2017-08-02 21:47:46 Re: Fwd: Planner oversight for GIN indices?