Thread: Table alias and inherited tables

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

nevermind.. guess there was a problem with the query condition itself

regards
- Amol

On 05/04/10 22:42, Amol Chiplunkar wrote:
> 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
>
>
>
>
>