"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> What exactly is the advantage in using VIEWs?
A level of logical indirection between the application and the physical
data schema. There are no performance benefits.
> I get the impression that the
> SELECT query it is based on is cached (ie. a cached query plan).
Nope. If there's something in the docs that makes you think so,
point out so I can fix it ;-)
regards, tom lane