[GENERAL] select md5 result set
От
Peter Koukoulis
Тема
[GENERAL] select md5 result set
Дата
Msg-id
CABpxA9hX3m8X2w9dyZyhxXcRMStXo1BspGbVCWegk=te0Es8vA@mail.gmail.com
Список
Дерево обсуждения
[GENERAL] select md5 result set Peter Koukoulis <pkoukoulis@gmail.com>
Re: [GENERAL] select md5 result set "David G. Johnston" <david.g.johnston@gmail.com>
Re: [GENERAL] select md5 result set Peter Koukoulis <pkoukoulis@gmail.com>
Re: [GENERAL] select md5 result set "David G. Johnston" <david.g.johnston@gmail.com>
Re: [GENERAL] select md5 result set Jeff Janes <jeff.janes@gmail.com>
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 по дате отправления
