On Sun, Aug 30, 2009 at 07:33:52PM -0300, Jorge Godoy wrote: > Hi! > > > Is it possible to use WITH queries ( > http://www.postgresql.org/docs/8.4/interactive/queries-with.html) on VIEWs? > > I have a rather complex view that I could optimize with it...
A WITH query can go anywhere any other read-only (for now) row-returning query can, so top-level SELECTs, sub-selects, etc. Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
