Re: Getting a grip on nested intervals and matrix encoding

On Jul 2, 2:45 pm, creecode <creec..._at_gmail.com> wrote:
> 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

http://vadimtropashko.wordpress.com/2010/07/03/more-errata-ancestor-query-in-matrix-encoding/ Received on Sat Jul 03 2010 - 03:03:06 CEST