Re: [GENERAL] Table alias and inherited tables

2010-05-05 Thread Amol Chiplunkar
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 rule

[GENERAL] Table alias and inherited tables

2010-05-05 Thread Amol Chiplunkar
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 child