On Thu, May 8, 2008 at 4:16 AM, Julius Tuskenis <julius@xxxxxxxx> 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.
