Re: [GENERAL] Using WITH queries on VIEWs

2009-08-30 Thread David Fetter
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 re

[GENERAL] Using WITH queries on VIEWs

2009-08-30 Thread Jorge Godoy
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... Regards, -- Jorge Godoy