Home > mailing lists

Using WITH queries on VIEWs - Mailing list pgsql-general

From	Jorge Godoy
Subject	Using WITH queries on VIEWs
Date	August 30, 2009 22:34:22
Msg-id	175c742d0908301533u7bceaf43pa4d08177ecb81717@mail.gmail.com Whole thread Raw
Responses	Re: Using WITH queries on VIEWs (David Fetter <david@fetter.org>)
List	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@gmail.com>

From: Pavel Stehule
Date: 30 August 2009, 20:36:58
Subject: Re: convert epoch to date

From: bilal ghayyad
Date: 30 August 2009, 22:38:09
Subject: $Body$