How the function written on pl/pgsql can be called by the function written on plperl.

Anatoly Okishev wrote:

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 wrote:

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

If i call this function from pl/pgsql it's worked, but i want to call this
function from plperl..

Anatoly Okishev

In 8.0beta: http://candle.pha.pa.us/main/writings/pgsql/sgml/plperl-database.html

and in 7.4.x: http://www.postgresql.org/docs/7.4/interactive/plperl-database.html

On Tue, 16 Nov 2004 10:19:01 +0500, Anatoly Okishev <rolly74@mail.ru> wrote:

Anatoly Okishev wrote:

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

If i call this function from pl/pgsql it's worked, but i want to call this
function from plperl..

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

--
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer