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
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
