Re: Using WITH queries on VIEWs

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 <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate