Re: Getting a grip on nested intervals and matrix encoding

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 =

• that isn't right **

Toodle-loooooooooo.............
creecode Received on Fri Jul 02 2010 - 23:45:50 CEST