Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Message-ID:	<20040827141759.81680.qmail@web41411.mail.yahoo.com>
Date:	Fri, 27 Aug 2004 07:17:59 -0700 (PDT)
From:	Kumar Pandey <kpandeyktm AT yahoo DOT com>
Subject:	Any working PL./Perl instance of - Postgres 7.4.5-1,perl-5.8.5 - on -XP home or Win 2000?
To:	cygwin AT cygwin DOT com
MIME-Version:	1.0
Note-from-DJ:	This may be spam

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/

- Raw text -