Re: Using WITH queries on VIEWs
От
David Fetter
Тема
Re: Using WITH queries on VIEWs
Дата
Msg-id
20090830224646.GI20482@fetter.org
Ответ на
Using WITH queries on VIEWs (Jorge Godoy)
Список
Дерево обсуждения
Using WITH queries on VIEWs Jorge Godoy <jgodoy@gmail.com>
Re: Using WITH queries on VIEWs David Fetter <david@fetter.org>
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 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
В списке pgsql-general по дате отправления
