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