On Tue, Nov 4, 2008 at 09:02, Jeff <threshar(at)torgo(dot)978(dot)org> wrote:
> I've ran into this interesting problem.
> It seems that while you can call sort() in a trusted plperl func you cannot
> access $a & $b which effectively makes it useless.
Hrm works for me if I take out the elog from sort()
create or replace function trustedsort()
returns int
as $$
my @arr = qw(5 4 3 2 1);
my @sorted = sort { $a <=> $b } @arr;
elog(NOTICE, join(' ', @sorted));
return 1;
$$
language 'plperl';
SELECT trustedsort();
NOTICE: 1 2 3 4 5
trustedsort
-------------
1
(1 row)