Re: How the function written on pl/pgsql can be called

#1

Anatoly Okishev wrote:

Quote:

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

---------------------------(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

#2

Quote:

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

#3

In 8.0beta: http://candle.pha.pa.us/main/writing...-database.html

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

On Tue, 16 Nov 2004 10:19:01 +0500, Anatoly Okishev <rolly74 (AT) mail (DOT) ru> wrote:

Quote:

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 (AT) gmail (DOT) com
GPLS -- PINES Development
Database Developer

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: How the function written on pl/pgsql can be called

comp.databases.postgresql.general comp.databases.postgresql.general

Re: How the function written on pl/pgsql can be called - 11-15-2004 , 03:28 AM

Re: How the function written on pl/pgsql can be called by the function written on plperl. - 11-15-2004 , 11:19 PM

Re: How the function written on pl/pgsql can be called by the function written on plperl. - 11-16-2004 , 05:28 AM