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@xxxxxxx> 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@xxxxxxxxx GPLS -- PINES Development Database Developer ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
