Using WITH queries on VIEWs

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Using WITH queries on VIEWs
Date: 2009-08-30 22:33:52
Message-ID: 175c742d0908301533u7bceaf43pa4d08177ecb81717@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 <jgodoy(at)gmail(dot)com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bilal ghayyad 2009-08-30 22:37:56 $Body$
Previous Message Pavel Stehule 2009-08-30 20:36:45 Re: convert epoch to date