Search Postgresql Archives

Re: Table alias and inherited tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux