Re: are views obsolete ?

Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> given the power of SETOF/ROWTYPE functions etc are select-only
> views becoming obsolete/redundant ?

Not hardly.  The planner can optimize queries involving views, since it
can see what's inside the view definition.  SRFs are black boxes and
thus not optimizable.  For example, in
    SELECT * FROM my_srf() WHERE foo
there's no way to push the "foo" condition down inside my_srf().

            regards, tom lane