Thanks Ilja for responding.
Since this operation and consequently query is going to be executed very frequently (thousands of times every second), I am concerned that it might tax the database engine to breakdown

. Fyi, most of the joins in the query are outer joins.
I am planning on doing some benchmarking today to check out the point of failure.