Re: Must class qualifier be an entire field?

• Previous message: Mike Kienenberger: "Re: Must class qualifier be an entire field?"
• In reply to: Török Péte: "How to set default values or use triggers for a column?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I've not actually tried that, but I wouldn't really advise it if it
did work. Could lead to unexpected problems down the road, such as
another personType starting with a "C", etc. It might be interesting
to try it, though, just to see how it worked. :-)

/dev/mrg

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
>

• Next message: Andrus Adamchik: "Re: Must class qualifier be an entire field?"
• Previous message: Mike Kienenberger: "Re: Must class qualifier be an entire field?"
• In reply to: Török Péte: "How to set default values or use triggers for a column?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Tue Feb 27 2007 - 09:29:19 EST