Re: intersecting ranges

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Mon, 25 Jul 2005 17:16:32 +0000 (UTC)
Message-ID: <dc36pg$9cg$1@klatschtante.init7.net>

On 2005-07-25, jtoulier <jtoulier_at_yahoo.com> wrote:
> 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.

No, but you can proram one.

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/

Received on Mon Jul 25 2005 - 12:16:32 CDT