hi all How are function parameters generally passed in postgresql. More specifically when we pass a variable to a plpgsql function is passed by value or by reference Thank You ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)