PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15426
PG Version10.5
OSAny
Opened2018-10-10 17:34:01+00
Reported byIvan Ustûžanin
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15426
Logged by:          Ivan Ustûžanin
Email address:      (redacted)
PostgreSQL version: 10.5
Operating system:   Any
Description:        

Executing
SELECT * FROM xmltable(
    '.' PASSING '<r/>'
    COLUMNS
    c1 Text PATH 'name()',
    c2 Text DEFAULT c1
);
complains that column c1 does not exist.
However the documentation states that it is possible to use prior columns in
default expressions of later columns.

Messages

DateAuthorSubject
2018-10-10 17:34:01+00=?utf-8?q?PG_Bug_reporting_form?=BUG #15426: A prior column in a default expression of an xmltable() call does not exist