Re: Must class qualifier be an entire field?

From: Mike Kienenberger (mkienen..mail.com)
Date: Tue Feb 27 2007 - 09:24:39 EST

  • Next message: Michael Gentry: "Re: Must class qualifier be an entire field?"

    I've not used single-table inheritance, but I'm pretty sure the
    qualifier is just a qualifier and completely independent of columns.

    It could be "0 = mod(random(), 2)" if the database supported the functions.

    In this case, the fastest thing to do is to just test your alternate qualifier.

    On 2/27/07, Török Péter <torok..llround.net> wrote:
    >
    >
    > Hello,
    > is it necessary to have a full column reserved for the class qualifier in
    > case of single table inheritance?
    > I.e. instead of qualifier
    > personType = 'CUSTOMER'
    > would something like
    >
    > personType like 'C%'
    > work? Anyone tried such a thing yet?
    > Thanx in advance,
    > Péter
    >

    This archive was generated by hypermail 2.0.0 : Tue Feb 27 2007 - 09:25:12 EST