++no

Again, invoking a subquery is going to let the database engine know: "OK, get all that stuff first, and THEN work on the rest of the query."
If he simple function call is giving you a more lazy evaluation evaluation, that might explain what's occurring.

Is there a threat (even a theoretical one) of the server going into an infinite loop based upon what you're doing?
It may be that the database engine requires the subquery to break the possibility of a cycle in the code, and sequence the computation.

Take a couple pilz and call me in the morning.

To this day, males 18+ must register. Those who do not cannot receive Federal financial aid, nor work as a GS or contract employee for the Fed.

Did it do a 4G inverted dive?

Eternal Champignon?

If that was him that mod bombed me on your JE, JC, then I'll just go mod him up for spite.

Pfft. I invented the wheel with round corners.

Ah, thanks.

[cryptic response]

Hooray! Congrats!

Just had boy #2 a month ago. Life is good.