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 <[EMAIL PROTECTED]> 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