Re: Table alias and inherited tables

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
>
>
>
>
>