On Sat, May 21, 2005 at 04:04:36PM -0400, Andrew Dunstan wrote: Andrew,
> it works like this: > > andrew=# create or replace function foo() returns text language plperl > as $$ $x = 1; return 'hello'; $$; > CREATE FUNCTION > andrew=# select foo(); > ERROR: creation of Perl function failed: Global symbol "$x" requires > explicit package name at (eval 11) line 1. Hmm, is there a way to have a validator function and have the strict check at function creation too? I know these things are reported with perl -c, not sure if they can be reached with the C interface. -- Alvaro Herrera (<alvherre[a]surnet.cl>) Dios hizo a Adán, pero fue Eva quien lo hizo hombre. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster