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
Content-Type: text/plain; charset=us-ascii
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/