Re: Getting a grip on nested intervals and matrix encoding

From: creecode <creecode_at_gmail.com>
Date: Fri, 2 Jul 2010 14:45:50 -0700 (PDT)
Message-ID: <395b2b48-e7d7-45ac-8e9d-93ac446e201c_at_x18g2000pro.googlegroups.com>



On Jul 2, 10:21 am, Tegiri Nenashi <tegirinena..._at_gmail.com> wrote:

> select descendant.name
> from hierarchy node, hierarchy descendant
> where node.name = 'JONES'
> and descendant.a11*node.a21-descendant.a11*node.a22 >=
> node.a11*descendant.a21-node.a12*descendant.a21
> and descendant.a11 * node.a21 <= descendant.a21 * node.a11;

Hello Tegiri,

Thank you for your response. Unfortunately your query doesn't work for me. Perhaps I've made an error somewhere.

SELECT descendant.name FROM MatrixTreeNodes AS descendant, MatrixTreeNodes AS node WHERE descendant.a11 * node.a21 -

descendant.a11 * node.a22 >=
node.a11 * descendant.a21 - node.a12 * descendant.a21 AND
descendant.a11 * node.a21 <= descendant.a21 * node.a11 AND node.name =
'FORD'; name
SCOTT
FORD
SMITH
  • that isn't right **

Toodle-loooooooooo.............
creecode Received on Fri Jul 02 2010 - 16:45:50 CDT

Original text of this message