intersecting ranges

Hello all,

I have four numeric variables:

min_desired_price := 10;
max_desired_price := 50;

min_real_price := 40;
max_real_price := 70;

Does PL/SQL have a function so I can say if both ranges have an intersection? For example if the desired prices "fall" in the real range.

Thanks a lot

Joseph Received on Mon Jul 25 2005 - 11:57:43 CDT