Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Koukoulis
Subject [GENERAL] select md5 result set
Date
Msg-id CABpxA9hX3m8X2w9dyZyhxXcRMStXo1BspGbVCWegk=te0Es8vA@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] select md5 result set  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Fwd: Planner oversight for GIN indices?
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] select md5 result set