Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Using WITH queries on VIEWs
- From: David Fetter <david(at)fetter(dot)org>
- To: Jorge Godoy <jgodoy(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Using WITH queries on VIEWs
- Date: Sun, 30 Aug 2009 15:46:46 -0700
- Message-id: <20090830224646.GI20482@fetter.org> <text/plain>
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(at)fetter(dot)org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
- References:
- Using WITH queries on VIEWs
- From: Jorge Godoy
- Using WITH queries on VIEWs
- Prev by Date: Re: $Body$
- Next by Date: short circuit joins
- Previous by thread: Using WITH queries on VIEWs
- Next by thread: $Body$
- Indexes: