info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: [BUGS] BUG #13810: cursor_to_xml ignores tableforest parameter
1 view
Skip to first unread message
Peter Eisentraut
Aug 2, 2016, 1:49:08 PM8/2/16
to
On 12/9/15 9:07 AM, fi...@jirsak.org wrote:
> CREATE FUNCTION test_cursor_to_xml() RETURNS xml AS $$
> DECLARE
> curs CURSOR FOR SELECT generate_series(1, 5);
> BEGIN
> OPEN curs;
> RETURN cursor_to_xml(curs, 10, TRUE, FALSE, '');
> END;
> $$ LANGUAGE plpgsql;
>
> SELECT test_cursor_to_xml();
>
>
> This returns XML forrest instead of XML document with single root.
You're right, this should have a <table>...</table> around it, like
query_to_xml() does.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
> CREATE FUNCTION test_cursor_to_xml() RETURNS xml AS $$
> DECLARE
> curs CURSOR FOR SELECT generate_series(1, 5);
> BEGIN
> OPEN curs;
> RETURN cursor_to_xml(curs, 10, TRUE, FALSE, '');
> END;
> $$ LANGUAGE plpgsql;
>
> SELECT test_cursor_to_xml();
>
>
> This returns XML forrest instead of XML document with single root.
You're right, this should have a <table>...</table> around it, like
query_to_xml() does.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-bugs mailing list (pgsql...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
0 new messages