Re: [GENERAL] select md5 result set

Поиск
Список
Период
Сортировка
От Peter Koukoulis
Тема Re: [GENERAL] select md5 result set
Дата
Msg-id CABpxA9iyKqjvqEyAkxhUB56VSuS1AMubtdMmgyqaLMhyx61HtA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] select md5 result set  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [GENERAL] select md5 result set
Список pgsql-general
Дерево обсуждения
david, thanks for the help.

Would this be the equivalent, for the statement in your email, for table TEST1 (x integer, y varchar(20)):

ft_node=# SELECT md5(string_agg(vals::text, ''))
ft_node-# from (select x,y from test1) vals(x,y);
?

Peter


On Thu, 3 Aug 2017 at 00:25 David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Aug 2, 2017 at 3:42 PM, Peter Koukoulis <pkoukoulis@gmail.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.

В списке pgsql-general по дате отправления: