surabhi.ahuja wrote:
patName := trim($1); select trim(trailing `^` from patName) INTO patName; trim(patName);
I think this line should contain an assignment.
-- Alban Hertroys ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match