Re: filtering after join

Поиск
Список
Период
Сортировка
От andrew
Тема Re: filtering after join
Дата
Msg-id 29d3b0b90601260454g35817213o7d5a0e8a1e53ddf7@mail.gmail.com
обсуждение исходный текст
Ответ на Re: filtering after join  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: filtering after join  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-sql
How will the query planner do for a nesting query? Treat the
subqueries as multiple queries and then link them together?
where can I find the information (codes or documents)?
Thanks.
On 1/26/06, Peter Eisentraut <peter_e@gmx.net> wrote:
> andrew wrote:
> > But the function foo() would produce different values for the two
> > queries, so the result will be different.
> > A simple example is foo() computes the sum of all the integer fields
> > of the input record.
>
> OK, I see now where you're getting at.  You want to combine the record
> type of A and B into one.  Then the proposed solution is right.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>


--
andrew


В списке pgsql-sql по дате отправления:

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: Changing the transaction isolation level within the stored
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Changing the transaction isolation level within the stored