BUG #13810: cursor_to_xml ignores tableforest parameter - Mailing list pgsql-bugs

From filip@jirsak.org
Subject BUG #13810: cursor_to_xml ignores tableforest parameter
Date
Msg-id 20151209140708.877.66922@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13810: cursor_to_xml ignores tableforest parameter  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13810
Logged by:          Filip Jirsák
Email address:      filip@jirsak.org
PostgreSQL version: 9.4.5
Operating system:   x86_64-pc-linux-gnu
Description:

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.

pgsql-bugs by date:

Previous
From: alexander.ashurkov@gmail.com
Date:
Subject: BUG #13809: Reassign owned throws error
Next
From: Andres Freund
Date:
Subject: Re: BUG #13808: Upsert not working