From: | Amol Chiplunkar <amol(dot)chiplunkar(at)oracle(dot)com> |
---|---|
To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Table alias and inherited tables |
Date: | 2010-05-05 06:19:06 |
Message-ID: | 4BE10DDA.7060106@oracle.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Shoaib Mir | 2010-05-05 06:28:08 | Re: no such file euc2004... while initdb 9.0Beta |
Previous Message | Scott Marlowe | 2010-05-05 06:18:57 | Re: Savepoint and prepared transactions |