Displaying 1 result from an estimated 1 matches for "_property_".
Did you mean:
_property
2009 Jun 29
3
Table Inheritance based on a function
....
The Fowler example mentions a ''type'' column and RoR implements this
directly - which we consider inconsistent with DB abastraction:
It forces a ''type'' column in the database following the application -
instead of the application asking the DB to derive the type _property_
from immanent record properties.
Practically, we would like to have a database function or condition to
control the type.
As a first step this can be done like this:
Select *, CASE WHEN some_condition THEN ''a'' ELSE ''b'' END AS type
FROM table1;
We could defin...