Re: [EXT] Re: Passing XML column in an array

2022-02-10 Thread Garfield Lewis
>The most obvious theory is that there are some nulls in the XT.XMLT1C1 >column. Since your code isn't bothering to check pXmlDataNulls[ix], >it would hit a null-pointer dereference when accessing pXmlData[ix]. > > regards, tom lane Thx, Tom... my bad... Regard

Re: Passing XML column in an array

2022-02-10 Thread Tom Lane
Garfield Lewis writes: > I am trying to pass an array into a new function I am creating called > lzxmlexists via the following statement: > wdbs=# SELECT "XT"."ROWKEY" , "XT"."XMLT1C1" FROM "LZQAAS"."T642_XML_T1" "XT" > WHERE "ROWKEY"=64201 AND lzxmlexists( ' $XTX//DeptName[ . = $Dn]', > '

Passing XML column in an array

2022-02-10 Thread Garfield Lewis
Hi All, I have the following code: 141 if ( 0 != iXmlArrDim ) { 142 Datum*pXmlData = NULL; 143 bool *pXmlDataNulls = NULL; 144 uint32_t iXmlCount = 0; 145 bool bFirstTime= true; 146 147 Assert( XMLOID == ARR_ELEMENTS( p