Hello, 

I found different behavior of array inicialised from plperl than plpgsql.
I use code from my prev. mail

tarif=# select speed(10);
         speed
-----------------------
 {0,1,2,3,4,5,6,7,8,9}
(1 row)

Time: 2,304 ms
tarif=# select speed2(10);
                        speed2
------------------------------------------------------
 {1.00,2.00,3.00,4.00,5.00,6.00,7.00,8.00,9.00,10.00}
(1 row)

Time: 0,863 ms

the array from speed2 is ok, but array from speed is mal formated. 
I declare all function as numeric(7,2)[]

when I change init value on 0.01, than results are equal

regards
Pavel Stehule


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to