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 -~----------~----~----~----~------~----~------~--~---