On Fri, Mar 28, 2025 at 6:05 PM Richard Guo <guofengli...@gmail.com> wrote: > Nice catch. Yeah, is_not_null is a valid column option in xmltable. > In you example, the value of the is_not_null option is "|| 'c'", which > is interpreted as an A_Expr. > > I wonder if the value's type should be checked earlier, rather than at > the last minute.
Hmm, I wonder if we should allow the use of the 'is_not_null' keyword in xmltable. According to the doc, it seems that users should declare NULL or NOT NULL for a column by specifying [NOT NULL | NULL] for the column. Thanks Richard
