I wrote:
> That seems like a pretty fishy way to do it. Are you saying that
> Memoize is never applicable if there aren't outer joins in the
> query? Without OJs there probably won't be any PHVs.
Oh, scratch that, I see you mean this is an additional way to do it
not the only way to do it. But I'm confused why it works for
t1.two+1 AS c1
but not
t1.two+t2.two AS c1
Those ought to look pretty much the same for this purpose.
regards, tom lane