Re: Strange plpgsql performance, diff plperl and plpgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
Cc: "Karl O(dot) Pinc" <kop(at)meme(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Strange plpgsql performance, diff plperl and plpgsql
Date: 2005-04-04 01:02:18
Message-ID: 13741.1112576538@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> writes:
> the array from speed2 is ok, but array from speed is mal formated.

They both look OK to me.

> I declare all function as numeric(7,2)[]

Type modifiers applied to function arguments and results are generally
ignored. What you have here is functions returning numeric[], and not
anything else. In the plpgsql example the coercion to numeric(7,2)
happens because you stored into a local variable declared that way,
but there's nothing to make it happen in the plperl example.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-04-04 01:04:27 Re: Strange plpgsql performance -- arithmetic, numeric() type, arrays
Previous Message Tony Caduto 2005-04-04 00:57:53 Question about format_type function