Hi,
I notice that for the following:
Table Base with say columns col1, col2
Table Child1 inherits(Base)
Table Child2 inherits(Base)
With check constraints and rules to insert the rows to appropriate
tables defined.
Inserts work as expected.
select * from Base; returns rows from both the children
But something like
select b from base b where b.col1=<condition>;
returns 0 rows even when there are rows in one of the child tables
that satisfy the condition.
Is this expected ?
thx
- Amol