"Christopher Kings-Lynne" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org