# HG changeset patch
# User Goffi <goffi@goffi.org>
# Date 1449009152 -3600
# Node ID 3c2705199108607264bd710b66a8f5bc06742c0e
# Parent  b8b25efae0bc86adb5c7ee6ec2688b94ffa9133b
sat_pubsub_update_0_1.sql now also updates comment nodes

diff -r b8b25efae0bc -r 3c2705199108 db/sat_pubsub_update_0_1.sql
--- a/db/sat_pubsub_update_0_1.sql	Wed Nov 25 22:48:59 2015 +0100
+++ b/db/sat_pubsub_update_0_1.sql	Tue Dec 01 23:32:32 2015 +0100
@@ -28,5 +28,5 @@
                         xmlelement(name entry, xmlattributes('http://www.w3.org/2005/Atom' as xmlns), array_to_string(xpath('/item/entry/*', data::xml)::text[], '')::xml),
                         XMLPARSE(CONTENT NULLIF(array_to_string(xpath('/item/entry/following-sibling::*', data::xml)::text[],''),'')))
              FROM nodes WHERE nodes.node_id = items.node_id
-             AND node = 'urn:xmpp:microblog:0'
+             AND (node = 'urn:xmpp:microblog:0' or node LIKE 'urn:xmpp:comments:%')
              AND XMLEXISTS('/item/entry' PASSING (data::xml));