Dude, you should be WRITING them! On 1/25/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---