Anatoly Okishev wrote:If i call this function from pl/pgsql it's worked, but i want to call this function from plperl..How the function written on pl/pgsql can be called by the function written on plperl.
Error is:
error from function: Undefined subroutine &Safe::Root2::get_national_code called.....
You probably need to be calling "SELECT get_national_code(...)" to access it via a standard query.
-- Richard Huxton Archonet Ltd
Anatoly Okishev
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match