This is the mail archive of the
cygwin
mailing list for the Cygwin project.
Any working PL./Perl instance of - Postgres 7.4.5-1,perl-5.8.5 - on -XP home or Win 2000?
- From: Kumar Pandey <kpandeyktm at yahoo dot com>
- To: cygwin at cygwin dot com
- Date: Fri, 27 Aug 2004 07:17:59 -0700 (PDT)
- Subject: 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/