Re: [Fwd: performance: view or function?]

["Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>]

On Thu, May 8, 2008 at 4:16 AM, Julius Tuskenis <julius(at)nsoft(dot)lt> wrote:
> Hello,
>
>  I have one question - what is the difference between the view and a
> function returning a data set? I mean the performance. Which is better to
> use? If its the same, I would use functions, because I could use other
> languages not just SQL to get the results I want.

Note that functional indexes may be a good choice for certain actions.
 If you always look up tuples based on something like "where
a*80+b<100 or something then a functional index on ((a*80+b)) might be
more useful than a view.  You can also create a custom immutable
function and index on that to make it a bit cleaner.