I wrote: > The point is that the view won't be flattened if there are nonvolatile > functions in its SELECT list.
Sheesh ... s/nonvolatile/volatile/ of course ... this thread seems afflicted with getting-it-backward disease :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings