Re: what is sublinks in query planner?

Поиск
Список
Период
Сортировка
От Sandeep Gupta
Тема Re: what is sublinks in query planner?
Дата
Msg-id CAAywg7s2Zcv6-dR4m7S7A3epDBj4kFH3V_S92xOFxt5bNK+Yeg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: what is sublinks in query planner?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi Tom,

 Sure. Thanks for the info. This helps. I will look into primnodes.h as well.

-Sandeep






On Fri, Mar 28, 2014 at 3:56 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Sandeep Gupta <gupta.sandeep@gmail.com> writes:
>  I looked for description of sublinks in the code as well as online but
> failed to come with any information. Was wondering someone can provide a
> line or two of what sublinks are suppose to do?

They're sub-SELECTs used in expression contexts (ie, not directly in a
FROM list).  The comments for the SubLink and SubPlan node types in
primnodes.h may help you.

                        regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: what is sublinks in query planner?
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: PG choosing nested loop for set membership?