Re: [SQL] "AND", "OR" and Materialize :((((

2001-08-26 Thread Meszaros Attila
Hi, > > WHY SHALL IT MATERIALIZE A CONSTANT RESULT IN A LOOP OF 12 TIMES ?? > > [it would be enough to materialize only once, > > Which in fact is exactly what the materialize node is for. The reported > costs are pretty bogus, but AFAICT the plan is the right thing. Thanx for the

Re: [SQL] "AND", "OR" and Materialize :((((

2001-08-26 Thread Tom Lane
Meszaros Attila <[EMAIL PROTECTED]> writes: > WHY SHALL IT MATERIALIZE A CONSTANT RESULT IN A LOOP OF 12 TIMES ?? > [it would be enough to materialize only once, Which in fact is exactly what the materialize node is for. The reported costs are pretty bogus, but AFAICT the plan is the right t