From: | "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | PL/Ruby, INOUT parameters / SETOF record |
Date: | 2006-04-26 13:27:50 |
Message-ID: | 6C0CF58A187DA5479245E0830AF84F421D0C21@poweredge.attiksystem.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am testing PL/Perl under Postgresql 8.1.3, and I habe the following test
procedure:
--------------
CREATE FUNCTION perl_test(a inout integer, b inout integer, r1 out integer,
r2 out integer) SETOF record AS
'
my ($a, $b) = @_;
$r1 = $a + $b;
$r2 = $a * $b;
return_next {a => $a, b => $b, r1 => $r1, r2 => $r2};
return_next {a => $b, b => $a, r1 => $r1, r2 => $r2};
return undef;
' LANGUAGE plperl;
--------------
How would you translate that in PL/Ruby?
I have a link to http://moulon.inra.fr/ruby/plruby.html, which is apprently
the only documentation, and I find it quite hard to do the translation.
Thanks!
----------------------------------
Philippe Lang, Ing. Dipl. EPFL
Attik System
rte de la Fonderie 2
1700 Fribourg
Switzerland
http://www.attiksystem.ch
Tel: +41 (26) 422 13 75
Fax: +41 (26) 422 13 76
From | Date | Subject | |
---|---|---|---|
Next Message | Reid Thompson | 2006-04-26 13:35:24 | Linux Journal article - Open source baseball stats web site will use PostgreSQL |
Previous Message | Chris Kratz | 2006-04-26 13:19:41 | Ordering of records in group by not possible |