On Thu, May 8, 2008 at 4:16 AM, Julius Tuskenis <[EMAIL PROTECTED]> 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. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
