[9.1] unusable for large views - Mailing list pgsql-hackers

<div class="WordSection1"><p class="MsoNormal">Hello,<p class="MsoNormal"> <p class="MsoNormal"><span lang="EN-US">I
havetried 9.1.1 win64 version and when I am trying to declare a cursor for a very large view (lot of joins and
aggregatefunctions),</span><p class="MsoNormal"><span lang="EN-US">postgres is using around <b>3GB</b> of memory and
thequery <u>never returns</u>.</span><p class="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span
lang="EN-US">Sameproble selecting from the view without cursor.</span><p class="MsoNormal"><span
lang="EN-US"> </span><pclass="MsoNormal"><span lang="EN-US">Same query worked fine from 8.3.3 to 9.0.5.</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Should I change some configuration
paramsto have the same behavior as previous versions?</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal"><b><spanlang="EN-US"> </span></b><p class="MsoNormal"><b><span lang="EN-US"> </span></b><p
class="MsoNormal"><spanlang="EN-US">Tried on Win2008 server R2  64bit 8GB RAM.</span><p class="MsoNormal"><span
lang="EN-US">alsoon Win7 64bit 8GB RAM.</span><p class="MsoNormal"><b><span lang="EN-US">default
postgresql.conf</span></b><pclass="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span
lang="EN-US">Regards,</span><pclass="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span
lang="EN-US"> </span><pclass="MsoNormal"><span lang="EN-US">The view (!)</span><p class="MsoNormal"><span
lang="EN-US"> </span><pclass="MsoNormal"><span lang="EN-US">CREATE OR REPLACE VIEW articoli_rip_ven20110227_view AS
</span><pclass="MsoNormal"><span lang="EN-US"> </span>SELECT a.pk_id, a.articolo, a.articolo_f, a.origine, ( SELECT
ditte.attivita<pclass="MsoNormal">           FROM ditte<p class="MsoNormal">          WHERE ditte.partitario =
a.cod_fornit)AS dummy_1, a.descrizion, a.taglia, a.peso_spec, a.giacenza_colli, a.giacenza, rim.colli AS
rimanenza_colli,rim.quantita AS rimanenza_qta, rimass.colli AS rimanenza_ass_colli, rimass.quantita AS
rimanenza_ass_qta,COALESCE(b20.quantita, NULL::numeric, 0::numeric)::double precision + COALESCE(b21.quantita,
NULL::numeric,0::numeric)::double precision + COALESCE(b22.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b23.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b24.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b25.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b26.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b27.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b28.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b29.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b30.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b31.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b32.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b33.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b34.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b35.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b36.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b37.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b38.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b39.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b40.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b41.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b42.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b43.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b44.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b45.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b46.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b47.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b48.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b49.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b50.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b51.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b52.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b53.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b54.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b55.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b56.quantita,NULL::numeric, 0::numeric)::double precision + (COALESCE(rim.quantita, NULL::numeric, 0::numeric)
+COALESCE(rimass.quantita, NULL::numeric, 0::numeric))::double precision - (COALESCE(b1.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b2.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b3.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b4.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b5.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b6.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b7.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b8.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b9.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b10.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b11.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b12.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b13.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b14.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b15.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b16.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b17.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b18.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b19.quantita, NULL::numeric,
0::numeric)::doubleprecision) AS diff_qta, COALESCE(b1.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b2.colli::integer,NULL::integer, 0)::smallint + COALESCE(b3.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b4.colli::integer,NULL::integer, 0)::smallint + COALESCE(b5.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b6.colli::integer,NULL::integer, 0)::smallint + COALESCE(b7.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b8.colli::integer,NULL::integer, 0)::smallint + COALESCE(b9.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b10.colli::integer,NULL::integer, 0)::smallint + COALESCE(b11.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b12.colli::integer,NULL::integer, 0)::smallint + COALESCE(b13.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b14.colli::integer,NULL::integer, 0)::smallint + COALESCE(b15.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b16.colli::integer,NULL::integer, 0)::smallint + COALESCE(b17.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b18.colli::integer,NULL::integer, 0)::smallint + COALESCE(b19.colli::integer, NULL::integer, 0)::smallint AS
sum_colli_cli,COALESCE(b1.quantita, NULL::numeric, 0::numeric)::double precision + COALESCE(b2.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b3.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b4.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b5.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b6.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b7.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b8.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b9.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b10.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b11.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b12.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b13.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b14.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b15.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b16.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b17.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b18.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b19.quantita,NULL::numeric, 0::numeric)::double precision AS sum_qta_cli, COALESCE(b20.colli::integer,
NULL::integer,0)::smallint + COALESCE(b21.colli::integer, NULL::integer, 0)::smallint + COALESCE(b22.colli::integer,
NULL::integer,0)::smallint + COALESCE(b23.colli::integer, NULL::integer, 0)::smallint + COALESCE(b24.colli::integer,
NULL::integer,0)::smallint + COALESCE(b25.colli::integer, NULL::integer, 0)::smallint + COALESCE(b26.colli::integer,
NULL::integer,0)::smallint + COALESCE(b27.colli::integer, NULL::integer, 0)::smallint + COALESCE(b28.colli::integer,
NULL::integer,0)::smallint + COALESCE(b29.colli::integer, NULL::integer, 0)::smallint + COALESCE(b30.colli::integer,
NULL::integer,0)::smallint + COALESCE(b31.colli::integer, NULL::integer, 0)::smallint + COALESCE(b32.colli::integer,
NULL::integer,0)::smallint + COALESCE(b33.colli::integer, NULL::integer, 0)::smallint + COALESCE(b34.colli::integer,
NULL::integer,0)::smallint + COALESCE(b35.colli::integer, NULL::integer, 0)::smallint + COALESCE(b36.colli::integer,
NULL::integer,0)::smallint + COALESCE(b37.colli::integer, NULL::integer, 0)::smallint + COALESCE(b38.colli::integer,
NULL::integer,0)::smallint + COALESCE(b39.colli::integer, NULL::integer, 0)::smallint + COALESCE(b40.colli::integer,
NULL::integer,0)::smallint + COALESCE(b41.colli::integer, NULL::integer, 0)::smallint + COALESCE(b42.colli::integer,
NULL::integer,0)::smallint + COALESCE(b43.colli::integer, NULL::integer, 0)::smallint + COALESCE(b44.colli::integer,
NULL::integer,0)::smallint + COALESCE(b45.colli::integer, NULL::integer, 0)::smallint + COALESCE(b46.colli::integer,
NULL::integer,0)::smallint + COALESCE(b47.colli::integer, NULL::integer, 0)::smallint + COALESCE(b48.colli::integer,
NULL::integer,0)::smallint + COALESCE(b49.colli::integer, NULL::integer, 0)::smallint + COALESCE(b50.colli::integer,
NULL::integer,0)::smallint + COALESCE(b51.colli::integer, NULL::integer, 0)::smallint + COALESCE(b52.colli::integer,
NULL::integer,0)::smallint + COALESCE(b53.colli::integer, NULL::integer, 0)::smallint + COALESCE(b54.colli::integer,
NULL::integer,0)::smallint + COALESCE(b55.colli::integer, NULL::integer, 0)::smallint + COALESCE(b56.colli::integer,
NULL::integer,0)::smallint + (COALESCE(rim.colli, NULL::bigint, 0::bigint) + COALESCE(rimass.colli, NULL::bigint,
0::bigint))::smallintAS sum_colli_for, COALESCE(b20.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b21.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b22.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b23.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b24.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b25.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b26.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b27.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b28.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b29.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b30.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b31.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b32.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b33.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b34.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b35.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b36.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b37.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b38.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b39.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b40.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b41.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b42.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b43.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b44.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b45.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b46.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b47.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b48.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b49.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b50.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b51.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b52.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b53.quantita, NULL::numeric, 0::numeric)::double precision +
COALESCE(b54.quantita,NULL::numeric, 0::numeric)::double precision + COALESCE(b55.quantita, NULL::numeric,
0::numeric)::doubleprecision + COALESCE(b56.quantita, NULL::numeric, 0::numeric)::double precision +
(COALESCE(rim.quantita,NULL::numeric, 0::numeric) + COALESCE(rimass.quantita, NULL::numeric, 0::numeric))::double
precisionAS sum_qta_for, COALESCE(b20.colli::integer, NULL::integer, 0)::smallint + COALESCE(b21.colli::integer,
NULL::integer,0)::smallint + COALESCE(b22.colli::integer, NULL::integer, 0)::smallint + COALESCE(b23.colli::integer,
NULL::integer,0)::smallint + COALESCE(b24.colli::integer, NULL::integer, 0)::smallint + COALESCE(b25.colli::integer,
NULL::integer,0)::smallint + COALESCE(b26.colli::integer, NULL::integer, 0)::smallint + COALESCE(b27.colli::integer,
NULL::integer,0)::smallint + COALESCE(b28.colli::integer, NULL::integer, 0)::smallint + COALESCE(b29.colli::integer,
NULL::integer,0)::smallint + COALESCE(b30.colli::integer, NULL::integer, 0)::smallint + COALESCE(b31.colli::integer,
NULL::integer,0)::smallint + COALESCE(b32.colli::integer, NULL::integer, 0)::smallint + COALESCE(b33.colli::integer,
NULL::integer,0)::smallint + COALESCE(b34.colli::integer, NULL::integer, 0)::smallint + COALESCE(b35.colli::integer,
NULL::integer,0)::smallint + COALESCE(b36.colli::integer, NULL::integer, 0)::smallint + COALESCE(b37.colli::integer,
NULL::integer,0)::smallint + COALESCE(b38.colli::integer, NULL::integer, 0)::smallint + COALESCE(b39.colli::integer,
NULL::integer,0)::smallint + COALESCE(b40.colli::integer, NULL::integer, 0)::smallint + COALESCE(b41.colli::integer,
NULL::integer,0)::smallint + COALESCE(b42.colli::integer, NULL::integer, 0)::smallint + COALESCE(b43.colli::integer,
NULL::integer,0)::smallint + COALESCE(b44.colli::integer, NULL::integer, 0)::smallint + COALESCE(b45.colli::integer,
NULL::integer,0)::smallint + COALESCE(b46.colli::integer, NULL::integer, 0)::smallint + COALESCE(b47.colli::integer,
NULL::integer,0)::smallint + COALESCE(b48.colli::integer, NULL::integer, 0)::smallint + COALESCE(b49.colli::integer,
NULL::integer,0)::smallint + COALESCE(b50.colli::integer, NULL::integer, 0)::smallint + COALESCE(b51.colli::integer,
NULL::integer,0)::smallint + COALESCE(b52.colli::integer, NULL::integer, 0)::smallint + COALESCE(b53.colli::integer,
NULL::integer,0)::smallint + COALESCE(b54.colli::integer, NULL::integer, 0)::smallint + COALESCE(b55.colli::integer,
NULL::integer,0)::smallint + COALESCE(b56.colli::integer, NULL::integer, 0)::smallint + (COALESCE(rim.colli,
NULL::bigint,0::bigint) + COALESCE(rimass.colli, NULL::bigint, 0::bigint))::smallint - (COALESCE(b1.colli::integer,
NULL::integer,0)::smallint + COALESCE(b2.colli::integer, NULL::integer, 0)::smallint + COALESCE(b3.colli::integer,
NULL::integer,0)::smallint + COALESCE(b4.colli::integer, NULL::integer, 0)::smallint + COALESCE(b5.colli::integer,
NULL::integer,0)::smallint + COALESCE(b6.colli::integer, NULL::integer, 0)::smallint + COALESCE(b7.colli::integer,
NULL::integer,0)::smallint + COALESCE(b8.colli::integer, NULL::integer, 0)::smallint + COALESCE(b9.colli::integer,
NULL::integer,0)::smallint + COALESCE(b10.colli::integer, NULL::integer, 0)::smallint + COALESCE(b11.colli::integer,
NULL::integer,0)::smallint + COALESCE(b12.colli::integer, NULL::integer, 0)::smallint + COALESCE(b13.colli::integer,
NULL::integer,0)::smallint + COALESCE(b14.colli::integer, NULL::integer, 0)::smallint + COALESCE(b15.colli::integer,
NULL::integer,0)::smallint + COALESCE(b16.c<span lang="EN-US">olli::integer, NULL::integer, 0)::smallint +
COALESCE(b17.colli::integer,NULL::integer, 0)::smallint + COALESCE(b18.colli::integer, NULL::integer, 0)::smallint +
COALESCE(b19.colli::integer,NULL::integer, 0)::smallint) AS diff_colli, (COALESCE(b1.stato::integer, NULL::integer,
0)::smallint> 0 OR b1.articolo IS NULL) AND (COALESCE(b2.stato::integer, NULL::integer, 0)::smallint > 0 OR
b2.articoloIS NULL) AND (COALESCE(b3.stato::integer, NULL::integer, 0)::smallint > 0 OR b3.articolo IS NULL) AND
(COALESCE(b4.stato::integer,NULL::integer, 0)::smallint > 0 OR b4.articolo IS NULL) AND (COALESCE(b5.stato::integer,
NULL::integer,0)::smallint > 0 OR b5.articolo IS NULL) AND (COALESCE(b6.stato::integer, NULL::integer, 0)::smallint
>0 OR b6.articolo IS NULL) AND (COALESCE(b7.stato::integer, NULL::integer, 0)::smallint > 0 OR b7.articolo IS
NULL)AND (COALESCE(b8.stato::integer, NULL::integer, 0)::smallint > 0 OR b8.articolo IS NULL) AND
(COALESCE(b9.stato::integer,NULL::integer, 0)::smallint > 0 OR b9.articolo IS NULL) AND
(COALESCE(b10.stato::integer,NULL::integer, 0)::smallint > 0 OR b10.articolo IS NULL) AND
(COALESCE(b11.stato::integer,NULL::integer, 0)::smallint > 0 OR b11.articolo IS NULL) AND
(COALESCE(b12.stato::integer,NULL::integer, 0)::smallint > 0 OR b12.articolo IS NULL) AND
(COALESCE(b13.stato::integer,NULL::integer, 0)::smallint > 0 OR b13.articolo IS NULL) AND
(COALESCE(b14.stato::integer,NULL::integer, 0)::smallint > 0 OR b14.articolo IS NULL) AND
(COALESCE(b15.stato::integer,NULL::integer, 0)::smallint > 0 OR b15.articolo IS NULL) AND
(COALESCE(b16.stato::integer,NULL::integer, 0)::smallint > 0 OR b16.articolo IS NULL) AND
(COALESCE(b17.stato::integer,NULL::integer, 0)::smallint > 0 OR b17.articolo IS NULL) AND
(COALESCE(b18.stato::integer,NULL::integer, 0)::smallint > 0 OR b18.articolo IS NULL) AND
(COALESCE(b19.stato::integer,NULL::integer, 0)::smallint > 0 OR b19.articolo IS NULL) AS chk_cli,
(COALESCE(b20.stato,NULL::integer, 0)::smallint > 0 OR b20.articolo IS NULL) AND (COALESCE(b21.stato, NULL::integer,
0)::smallint> 0 OR b21.articolo IS NULL) AND (COALESCE(b22.stato, NULL::integer, 0)::smallint > 0 OR b22.articolo
ISNULL) AND (COALESCE(b23.stato, NULL::integer, 0)::smallint > 0 OR b23.articolo IS NULL) AND (COALESCE(b24.stato,
NULL::integer,0)::smallint > 0 OR b24.articolo IS NULL) AND (COALESCE(b25.stato, NULL::integer, 0)::smallint > 0
ORb25.articolo IS NULL) AND (COALESCE(b26.stato, NULL::integer, 0)::smallint > 0 OR b26.articolo IS NULL) AND
(COALESCE(b27.stato,NULL::integer, 0)::smallint > 0 OR b27.articolo IS NULL) AND (COALESCE(b28.stato, NULL::integer,
0)::smallint> 0 OR b28.articolo IS NULL) AND (COALESCE(b29.stato, NULL::integer, 0)::smallint > 0 OR b29.articolo
ISNULL) AND (COALESCE(b30.stato, NULL::integer, 0)::smallint > 0 OR b30.articolo IS NULL) AND (COALESCE(b31.stato,
NULL::integer,0)::smallint > 0 OR b31.articolo IS NULL) AND (COALESCE(b32.stato, NULL::integer, 0)::smallint > 0
ORb32.articolo IS NULL) AND (COALESCE(b33.stato, NULL::integer, 0)::smallint > 0 OR b33.articolo IS NULL) AND
(COALESCE(b34.stato,NULL::integer, 0)::smallint > 0 OR b34.articolo IS NULL) AND (COALESCE(b35.stato, NULL::integer,
0)::smallint> 0 OR b35.articolo IS NULL) AND (COALESCE(b36.stato, NULL::integer, 0)::smallint > 0 OR b36.articolo
ISNULL) AND (COALESCE(b37.stato, NULL::integer, 0)::smallint > 0 OR b37.articolo IS NULL) AND (COALESCE(b38.stato,
NULL::integer,0)::smallint > 0 OR b38.articolo IS NULL) AND (COALESCE(b39.stato, NULL::integer, 0)::smallint > 0
ORb39.articolo IS NULL) AND (COALESCE(b40.stato, NULL::integer, 0)::smallint > 0 OR b40.articolo IS NULL) AND
(COALESCE(b41.stato,NULL::integer, 0)::smallint > 0 OR b41.articolo IS NULL) AND (COALESCE(b42.stato, NULL::integer,
0)::smallint> 0 OR b42.articolo IS NULL) AND (COALESCE(b43.stato, NULL::integer, 0)::smallint > 0 OR b43.articolo
ISNULL) AND (COALESCE(b44.stato, NULL::integer, 0)::smallint > 0 OR b44.articolo IS NULL) AND (COALESCE(b45.stato,
NULL::integer,0)::smallint > 0 OR b45.articolo IS NULL) AND (COALESCE(b46.stato, NULL::integer, 0)::smallint > 0
ORb46.articolo IS NULL) AND (COALESCE(b47.stato, NULL::integer, 0)::smallint > 0 OR b47.articolo IS NULL) AND
(COALESCE(b48.stato,NULL::integer, 0)::smallint > 0 OR b48.articolo IS NULL) AND (COALESCE(b49.stato, NULL::integer,
0)::smallint> 0 OR b49.articolo IS NULL) AND (COALESCE(b50.stato, NULL::integer, 0)::smallint > 0 OR b50.articolo
ISNULL) AND (COALESCE(b51.stato, NULL::integer, 0)::smallint > 0 OR b51.articolo IS NULL) AND (COALESCE(b52.stato,
NULL::integer,0)::smallint > 0 OR b52.articolo IS NULL) AND (COALESCE(b53.stato, NULL::integer, 0)::smallint > 0
ORb53.articolo IS NULL) AND (COALESCE(b54.stato, NULL::integer, 0)::smallint > 0 OR b54.articolo IS NULL) AND
(COALESCE(b55.stato,NULL::integer, 0)::smallint > 0 OR b55.articolo IS NULL) AND (COALESCE(b56.stato, NULL::integer,
0)::smallint> 0 OR b56.articolo IS NULL) AS chk_for, b1.colli AS t_colli7717cli, b1.quantita AS t_qta7717cli,
b1.statoAS st7717cli, b1.eti_ok AS ok7717cli, b2.colli AS t_colli7705cli, b2.quantita AS t_qta7705cli, b2.stato AS
st7705cli,b2.eti_ok AS ok7705cli, b3.colli AS t_colli7715cli, b3.quantita AS t_qta7715cli, b3.stato AS st7715cli,
b3.eti_okAS ok7715cli, b4.colli AS t_colli7704cli, b4.quantita AS t_qta7704cli, b4.stato AS st7704cli, b4.eti_ok AS
ok7704cli,b5.colli AS t_colli7714cli, b5.quantita AS t_qta7714cli, b5.stato AS st7714cli, b5.eti_ok AS ok7714cli,
b6.colliAS t_colli7718cli, b6.quantita AS t_qta7718cli, b6.stato AS st7718cli, b6.eti_ok AS ok7718cli, b7.colli AS
t_colli7713cli,b7.quantita AS t_qta7713cli, b7.stato AS st7713cli, b7.eti_ok AS ok7713cli, b8.colli AS t_colli7708cli,
b8.quantitaAS t_qta7708cli, b8.stato AS st7708cli, b8.eti_ok AS ok7708cli, b9.colli AS t_colli7719cli, b9.quantita AS
t_qta7719cli,b9.stato AS st7719cli, b9.eti_ok AS ok7719cli, b10.colli AS t_colli7709cli, b10.quantita AS t_qta7709cli,
b10.statoAS st7709cli, b10.eti_ok AS ok7709cli, b11.colli AS t_colli7722cli, b11.quantita AS t_qta7722cli, b11.stato AS
st7722cli,b11.eti_ok AS ok7722cli, b12.colli AS t_colli7706cli, b12.quantita AS t_qta7706cli, b12.stato AS st7706cli,
b12.eti_okAS ok7706cli, b13.colli AS t_colli7716cli, b13.quantita AS t_qta7716cli, b13.stato AS st7716cli, b13.eti_ok
ASok7716cli, b14.colli AS t_colli7721cli, b14.quantita AS t_qta7721cli, b14.stato AS st7721cli, b14.eti_ok AS
ok7721cli,b15.colli AS t_colli7707cli, b15.quantita AS t_qta7707cli, b15.stato AS st7707cli, b15.eti_ok AS ok7707cli,
b16.colliAS t_colli7712cli, b16.quantita AS t_qta7712cli, b16.stato AS st7712cli, b16.eti_ok AS ok7712cli, b17.colli AS
t_colli7711cli,b17.quantita AS t_qta7711cli, b17.stato AS st7711cli, b17.eti_ok AS ok7711cli, b18.colli AS
t_colli7710cli,b18.quantita AS t_qta7710cli, b18.stato AS st7710cli, b18.eti_ok AS ok7710cli, b19.colli AS
t_colli7720cli,b19.quantita AS t_qta7720cli, b19.stato AS st7720cli, b19.eti_ok AS ok7720cli, b20.colli AS
t_colli18499for,b20.quantita AS t_qta18499for, b20.stato AS st18499for, b21.colli AS t_colli18502for, b21.quantita AS
t_qta18502for,b21.stato AS st18502for, b22.colli AS t_colli18469for, b22.quantita AS t_qta18469for, b22.stato AS
st18469for,b23.colli AS t_colli18475for, b23.quantita AS t_qta18475for, b23.stato AS st18475for, b24.colli AS
t_colli18472for,b24.quantita AS t_qta18472for, b24.stato AS st18472for, b25.colli AS t_colli18462for, b25.quantita AS
t_qta18462for,b25.stato AS st18462for, b26.colli AS t_colli18479for, b26.quantita AS t_qta18479for, b26.stato AS
st18479for,b27.colli AS t_colli18505for, b27.quantita AS t_qta18505for, b27.stato AS st18505for, b28.colli AS
t_colli18470for,b28.quantita AS t_qta18470for, b28.stato AS st18470for, b29.colli AS t_colli18477for, b29.quantita AS
t_qta18477for,b29.stato AS st18477for, b30.colli AS t_colli18465for, b30.quantita AS t_qta18465for, b30.stato AS
st18465for,b31.colli AS t_colli18453for, b31.quantita AS t_qta18453for, b31.stato AS st18453for, b32.colli AS
t_colli18457for,b32.quantita AS t_qta18457for, b32.stato AS st18457for, b33.colli AS t_colli18450for, b33.quantita AS
t_qta18450for,b33.stato AS st18450for, b34.colli AS t_colli18451for, b34.quantita AS t_qta18451for, b34.stato AS
st18451for,b35.colli AS t_colli18454for, b35.quantita AS t_qta18454for, b35.stato AS st18454for, b36.colli AS
t_colli18456for,b36.quantita AS t_qta18456for, b36.stato AS st18456for, b37.colli AS t_colli18455for, b37.quantita AS
t_qta18455for,b37.stato AS st18455for, b38.colli AS t_colli18458for, b38.quantita AS t_qta18458for, b38.stato AS
st18458for,b39.colli AS t_colli18501for, b39.quantita AS t_qta18501for, b39.stato AS st18501for, b40.colli AS
t_colli18504for,b40.quantita AS t_qta18504for, b40.stato AS st18504for, b41.colli AS t_colli18471for, b41.quantita AS
t_qta18471for,b41.stato AS st18471for, b42.colli AS t_colli18500for, b42.quantita AS t_qta18500for, b42.stato AS
st18500for,b43.colli AS t_colli18503for, b43.quantita AS t_qta18503for, b43.stato AS st18503for, b44.colli AS
t_colli18461for,b44.quantita AS t_qta18461for, b44.stato AS st18461for, b45.colli AS t_colli18478for, b45.quantita AS
t_qta18478for,b45.stato AS st18478for, b46.colli AS t_colli18467for, b46.quantita AS t_qta18467for, b46.stato AS
st18467for,b47.colli AS t_colli18474for, b47.quantita AS t_qta18474for, b47.stato AS st18474for, b48.colli AS
t_colli18459for,b48.quantita AS t_qta18459for, b48.stato AS st18459for, b49.colli AS t_colli18460for, b49.quantita AS
t_qta18460for,b49.stato AS st18460for, b50.colli AS t_colli18464for, b50.quantita AS t_qta18464for, b50.stato AS
st18464for,b51.colli AS t_colli18480for, b51.quantita AS t_qta18480for, b51.stato AS st18480for, b52.colli AS
t_colli18506for,b52.quantita AS t_qta18506for, b52.stato AS st18506for, b53.colli AS t_colli18452for, b53.quantita AS
t_qta18452for,b53.stato AS st18452for, b54.colli AS t_colli18463for, b54.quantita AS t_qta18463for, b54.stato AS
st18463for,b55.colli AS t_colli18466for, b55.quantita AS t_qta18466for, b55.stato AS st18466for, b56.colli AS
t_colli18473for,b56.quantita AS t_qta18473for, b56.stato AS st18473for</span><p class="MsoNormal"><span lang="EN-US">  
FROMarticoli a</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN articoli_rim_rip_ven20110227_view rim ON
rim.articolo= a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN
articoli_rim_ass_rip_ven20110227_viewrimass ON rimass.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN bolrighe b1 ON b1.numero = 7717 AND b1.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN bolrighe b2 ON b2.numero = 7705 AND b2.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN bolrighe b3 ON b3.numero = 7715 AND b3.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN bolrighe b4 ON b4.numero = 7704 AND b4.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN bolrighe b5 ON b5.numero = 7714 AND b5.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN bolrighe b6 ON b6.numero = 7718 AND b6.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN bolrighe b7 ON b7.numero = 7713 AND b7.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN bolrighe b8 ON b8.numero = 7708 AND b8.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN bolrighe b9 ON b9.numero = 7719 AND b9.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN bolrighe b10 ON b10.numero = 7709 AND b10.articolo = a.articolo</span><p
class="MsoNormal"><spanlang="EN-US">   LEFT JOIN bolrighe b11 ON b11.numero = 7722 AND b11.articolo =
a.articolo</span><pclass="MsoNormal"><span lang="EN-US">   LEFT JOIN bolrighe b12 ON b12.numero = 7706 AND b12.articolo
=a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN bolrighe b13 ON b13.numero = 7716 AND
b13.articolo= a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN bolrighe b14 ON b14.numero = 7721
ANDb14.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN bolrighe b15 ON b15.numero =
7707AND b15.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN bolrighe b16 ON b16.numero
=7712 AND b16.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN bolrighe b17 ON
b17.numero= 7711 AND b17.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN bolrighe b18
ONb18.numero = 7710 AND b18.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN bolrighe
b19ON b19.numero = 7720 AND b19.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN
magmodetb20 ON b20.numero = 18499 AND b20.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT
JOINmagmodet b21 ON b21.numero = 18502 AND b21.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">  
LEFTJOIN magmodet b22 ON b22.numero = 18469 AND b22.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN magmodet b23 ON b23.numero = 18475 AND b23.articolo = a.articolo</span><p
class="MsoNormal"><spanlang="EN-US">   LEFT JOIN magmodet b24 ON b24.numero = 18472 AND b24.articolo =
a.articolo</span><pclass="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b25 ON b25.numero = 18462 AND
b25.articolo= a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b26 ON b26.numero = 18479
ANDb26.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b27 ON b27.numero =
18505AND b27.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b28 ON
b28.numero= 18470 AND b28.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b29
ONb29.numero = 18477 AND b29.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet
b30ON b30.numero = 18465 AND b30.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN
magmodetb31 ON b31.numero = 18453 AND b31.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT
JOINmagmodet b32 ON b32.numero = 18457 AND b32.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">  
LEFTJOIN magmodet b33 ON b33.numero = 18450 AND b33.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN magmodet b34 ON b34.numero = 18451 AND b34.articolo = a.articolo</span><p
class="MsoNormal"><spanlang="EN-US">   LEFT JOIN magmodet b35 ON b35.numero = 18454 AND b35.articolo =
a.articolo</span><pclass="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b36 ON b36.numero = 18456 AND
b36.articolo= a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b37 ON b37.numero = 18455
ANDb37.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b38 ON b38.numero =
18458AND b38.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b39 ON
b39.numero= 18501 AND b39.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b40
ONb40.numero = 18504 AND b40.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet
b41ON b41.numero = 18471 AND b41.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN
magmodetb42 ON b42.numero = 18500 AND b42.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT
JOINmagmodet b43 ON b43.numero = 18503 AND b43.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">  
LEFTJOIN magmodet b44 ON b44.numero = 18461 AND b44.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN magmodet b45 ON b45.numero = 18478 AND b45.articolo = a.articolo</span><p
class="MsoNormal"><spanlang="EN-US">   LEFT JOIN magmodet b46 ON b46.numero = 18467 AND b46.articolo =
a.articolo</span><pclass="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b47 ON b47.numero = 18474 AND
b47.articolo= a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b48 ON b48.numero = 18459
ANDb48.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b49 ON b49.numero =
18460AND b49.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b50 ON
b50.numero= 18464 AND b50.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet b51
ONb51.numero = 18480 AND b51.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN magmodet
b52ON b52.numero = 18506 AND b52.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT JOIN
magmodetb53 ON b53.numero = 18452 AND b53.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">   LEFT
JOINmagmodet b54 ON b54.numero = 18463 AND b54.articolo = a.articolo</span><p class="MsoNormal"><span lang="EN-US">  
LEFTJOIN magmodet b55 ON b55.numero = 18466 AND b55.articolo = a.articolo</span><p class="MsoNormal"><span
lang="EN-US">  LEFT JOIN magmodet b56 ON b56.numero = 18473 AND b56.articolo = a.articolo;</span><p
class="MsoNormal"><spanlang="EN-US"> </span></div>