On 22/mar/08, at 17:55, Andreas Kretschmer wrote:

Tom Lane <[EMAIL PROTECTED]> schrieb:

Giorgio Valoti <[EMAIL PROTECTED]> writes:
maybe it’s a naive question but I was wondering if there is any
difference, from a performance point of view, between a view and a
function performing the same task,

Yes.  Usually the view will win.

*smile*

:-(
I was thinking about using using functions as the main way to interact with the database from an external application. The (supposed) rationale was to simplify the application code: you only have to worry about in and out function parameters. Are there any way to pass some hints to the planner? For example, could the IMMUTABLE/STABLE/VOLATILE modifiers be of some help?


Thank you
--
Giorgio Valoti





-
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to