Installed latest postgresql 8 on windows xp,
everything works fine with pl/pgsql; problems creating
a table with perl however:
CREATE OR REPLACE FUNCTION datetable() RETURNS integer
AS $$
CREATE TABLE tabletest
(
dayofmonth int4,
monthofyear int4,
theyear int4
)
$$
LANGUAGE 'plperlu' ;
But now when I try to run this function using query:
select * from datetable();
ERROR: error from Perl function: Can't locate object
method "dayofmonth" via package "int4" (perhaps you
forgot to load "int4"?) at line 3.
Any ideas appreciated. :-)
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com