This is the mail archive of the cygwin mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Any working PL./Perl instance of - Postgres 7.4.5-1,perl-5.8.5 - on -XP home or Win 2000?


If anyone with cygwin install of above combination
(available from yesterday) could run the tests
outlined below - I would very much appreciate it.
Please post your results.

Thanks
Kumar

Steps to install and test -
1) install plperl 

createlang plperl template1

2) create test table 

CREATE TABLE employee (
     name text,
     basesalary integer,
     bonus integer
 );

3) create test function

CREATE FUNCTION empcomp(employee) RETURNS integer AS '
     my ($emp) = @_;
     return $emp->{''basesalary''} +
$emp->{''bonus''};
 ' LANGUAGE plperl;

4) add a test data
insert into employee values('Sir Postgre',40,5);
 
5)use perl function - database crashes for me at this
point.

SELECT name, empcomp(employee) FROM employee;

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]