Magnus Hagander <magnus(at)hagander(dot)net> writes:
> IIRC, the behavior of MSSQL will depend on the query plan. If it's a
> plan that requires doesn't require materialization at all, it won't
> figure it out until you get there.
... which is pretty much what we do, too.
regards, tom lane