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. > > Rick > > On 1/25/07, Karl Guertin <[EMAIL PROTECTED]> wrote: >> >> On 1/25/07, Christopher Arndt <[EMAIL PROTECTED]> 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. >> >>> >> > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---