COALESCE....wow i need to read some SQL books again... :)
On Jan 25, 2007, at 11:17 AM, Rick Morrison wrote:
You could do this in a single join using COALESCE on the "fallback"
columns.
On 1/25/07, Karl Guertin <gray...@gmail.com> wrote:
On 1/25/07, Christopher Arndt <chri...@web.de> wrote:
It doesn't need to be recursive, just a two-level parent-child
relation. And I
don't want to add any columns, so I was thinking that table
inheritance is not
the right approach, but I'm not sure about that.
I was thinking that you could check parent_id for null or not null
and
map that way, but it doesn't look like the polymorphic mapper can
handle that. Ah well.