Re: Trouble in generating the plpgsql procedure code

nction$ > begin > return a + 1; > end; > $function$ > > Regards > > Pavel > > po 30. 9. 2024 v 12:09 odesílatel Nikhil Ingale > napsal: > >> Guys, >> I have a requirement to generate the plpgsql procedure code itself by >> reading the postgresql

Trouble in generating the plpgsql procedure code

7;) THEN' || chr(10) || ' SELECT count(1) INTO nCount FROM test.' || TstTableRec.TABLE_NAME || chr(10) || GetTrigClause(p_tdaowner, lower(TstTableRec.TABLE_NAME), ':NEW.') || ' AND STATUS_FLAG = 9 ; ' || chr(10) || ' '|| 'IF COALESCE(nCount,0) > 0 THEN' || chr(10) || Can someone help me here? Regards, Nikhil Ingale