Re: [PERFORM] Views and functions returning sets of records

2008-03-23 Thread Giorgio Valoti
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 t

Re: [PERFORM] Views and functions returning sets of records

2008-03-23 Thread Tom Lane
Giorgio Valoti <[EMAIL PROTECTED]> writes: > Are there any way to pass some hints to the planner? For example, > could the IMMUTABLE/STABLE/VOLATILE modifiers be of some help? Those don't really do anything for set-returning functions at the moment. As of 8.3 there is a ROWS attribute for SRFs