trouble with query
От | Luis Amigo |
---|---|
Тема | trouble with query |
Дата | |
Msg-id | 3C163C62.FE39402D@atc.unican.es обсуждение исходный текст |
Ответы |
Re: trouble with query
|
Список | 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 по дате отправления: