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