On Tue, Sep 8, 2015 at 3:24 PM, Tom Smith wrote:
> On Tue, Sep 8, 2015 at 3:51 PM, Merlin Moncure wrote:
>> On Mon, Sep 7, 2015 at 12:07 AM, Tom Smith
>> > How to force query planner "dynamically" generate plan to
>> > for each lateral select query as "t" changes.
>>
>> I think you're asking to
Almost all lateral query would be "dynamic sql" since it will vary as left
value changes.
perhaps query planner can mark it as "deferred" and during execution,
replacing the original planning with a newly generated plan.
Or we have to say lateral feature is not suitable for partitioned table.
On
On Mon, Sep 7, 2015 at 12:07 AM, Tom Smith wrote:
> Hi:
>
> I am using the wonderful lateral query feature like the following
>
> select * from generate_series (1,10,5) T(t),
>lateral (select * from P where t between t and t + 3)
>
> P is a parent table of a hundred partitions
> the id
Hi:
I am using the wonderful lateral query feature like the following
select * from generate_series (1,10,5) T(t),
lateral (select * from P where t between t and t + 3)
P is a parent table of a hundred partitions
the idea is to for each t value from 1 to 10 with step of 5,
get row
