Re: Can't understand how a query from the documentation works - Mailing list pgsql-novice

From Sergey Samokhin
Subject Re: Can't understand how a query from the documentation works
Date
Msg-id e42595410909091218l6cf7e929m2dee96eac4ad71d5@mail.gmail.com
Whole thread Raw
In response to Re: Can't understand how a query from the documentation works  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hello.

On Tue, Sep 8, 2009 at 11:40 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
> What will happen (at least conceptually) is that for each row
> of fdt, the whole sub-SELECT will be evaluated using that row's value
> of fdt.c1, producing a list of t2.c1 values.  Then, if the fdt row's
> value of c1 appears in that list, the fdt row will be included in the
> result.

Thanks for the detailed explanation - now I see where my mistake was!

--
Sergey Samokhin

pgsql-novice by date:

Previous
From: Raimon Fernandez
Date:
Subject: Re: different results using count(x)
Next
From: jr
Date:
Subject: Re: require some suggestion to write trigger function