trouble with query - Mailing list pgsql-novice

From Luis Amigo
Subject trouble with query
Date
Msg-id 3C163C62.FE39402D@atc.unican.es
Whole thread Raw
Responses Re: trouble with query
List pgsql-novice
we are getting:
ERROR:  fmgr_info: function 272362616: cache lookup failed
while executing attached query, may someone help us.
Thanks in advance
SELECT
    o_year,
    sum(CASE
        WHEN nation='BRAZIL'
        THEN volume
        ELSE 0
    END)/sum(volume) AS mkt_share
FROM(
    SELECT
        EXTRACT(YEAR FROM orders.orderdate) AS o_year,
        lineitem.extendedprice*(1-lineitem.discount) AS volume,
        n2.nation.name AS nation
    FROM
        part,
        supplier,
        lineitem,
        orders,
        customer,
        nation n1,
        nation n2,
        region
    WHERE
        part.partkey=lineitem.partkey
        AND supplier.suppkey=lineitem.suppkey
        AND lineitem.orderkey=orders.orderkey
        AND orders.custkey=customer.custkey
        AND customer.nationkey=n1.nation.nationkey
        AND n1.nation.regionkey=region.regionkey
        AND region.name='AMERICA'
        AND supplier.nationkey=n2.nation.nationkey
        AND orders.orderdate BETWEEN '1995/01/01' AND '1996/12/31'
        AND part.type='ECONOMY ANODIZED STEEL'
    ) AS all_nations
GROUP BY
    o_year
ORDER BY
    o_year;

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Multiple IN
Next
From: Leandro Fanzone
Date:
Subject: Re: Multiple IN