Re: Nested Coalescing possible in SQL?

From: Lennart Jonsson <lennart_at_kommunicera.umea.se>
Date: 4 Jun 2004 11:56:13 -0700
Message-ID: <6dae7e65.0406041056.36952f40@posting.google.com>

lennart_at_kommunicera.umea.se (Lennart Jonsson) wrote in message news:<6dae7e65.0406031939.1ed5fa49_at_posting.google.com>...

> lennart_at_kommunicera.umea.se (Lennart Jonsson) wrote in message news:<6dae7e65.0406022337.338870_at_posting.google.com>...
> > jlanfield2003_at_yahoo.com (Jeff Lanfield) wrote in message news:<235c483f.0406021038.13a1b83b_at_posting.google.com>...
>
> [...]
>
> Hmmm, I must have been just a little bit tired there ;-) Should read
> (diff in snd part of union):
>

and as you probably discovered already, it can be further simplified as

[...]

      union all
      select
          d.nodeid, d.nodeid,
          (select count(1) from ancestor where nodeid = d.nodeid) as
 depth
      from data d
      where d.color is not null

  )

[...]

/L Received on Fri Jun 04 2004 - 13:56:13 CDT