Actually, it's my fault. It turns out that the parent table was empty
and there was some other table that had all the other data.
Thanks, that was a quick response.
--Shuying
On 2/22/06, Michael Fuhr <mike@fuhr.org> wrote:
> On Wed, Feb 22, 2006 at 04:39:12PM +1100, Shuying Wang wrote:
> > I've got table x and table y which inherits table x. I want to get
> > items from table x which are not in table y. According to the
> > PostgreSQL documentation, the syntax would be "select * FROM ONLY x"
> > however this yields no rows, whereas something like "select * from x
> > where id not in (select id from y) " gives me what I want. Could
> > someone explain to me what I'm doing wrong using ONLY?
> Do any other tables inherit x? What's the output of the following
> query?