Search Postgresql Archives

PL/Ruby, INOUT parameters / SETOF record

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 

Attachment: smime.p7s
Description: S/MIME cryptographic signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux