ERROR: could not find array type for data type numeric[]

From: Suha Onay <suhaonay(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: could not find array type for data type numeric[]
Date: 2009-05-28 12:52:37
Message-ID: ec9caa670905280552y1575408q9a272f3124fd221d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I want to execute the following query in my Postgresql 8.3 but gives error:
ERROR: could not find array type for data type numeric[]

When i googled, no result.

SELECT
*
FROM (
SELECT
*
FROM(
SELECT
ARRAY(
(SELECT
(SELECT
-- The problem is here
ARRAY[sum(borc_alacak[1]), 0.0] as
kalantutar
-- if the line is not an array: "sum(borc_alacak[1]) as kalantutar" no
problem. But, i need more results in an array.

FROM (
SELECT
fat.xxx as borc_alacak, fat.vadetarihi
FROM scf_fatura fat
WHERE yyy

UNION ALL

SELECT
fissiz.xxx as borc_alacak, fissiz.vadetarihi
FROM scf_odeme_fissiz fissiz
WHERE yyy

) as ignore

WHERE vadetarihi <= tarihler[2] AND vadetarihi
>= tarihler[1]

) as kalantutar

FROM (
SELECT ARRAY[column1, column2] as tarihler
FROM
( VALUES ('2009-05-29'::date,
'2999-01-01'::date) ,
('2009-05-01'::date, '2009-05-28'::date) ,
('2009-04-01'::date, '2009-04-30'::date) ,
('2009-03-01'::date, '2009-03-31'::date) ,
('2009-02-01'::date, '2009-02-28'::date) ,
('2009-01-01'::date, '2009-01-31'::date) ,
('2008-12-01'::date, '2008-12-31'::date) , ('2008-11-01'::date,
'2008-11-30'::date) ,
('1899-01-01'::date, '2008-10-31'::date) )
as foo
) as ddd
)
) as tutarlar,

cari.*
FROM scf_carikart cari
WHERE cari.carikartkodu like '%DENEME%'
) as ignore
) AS ST

------------------
Some parts of the sql is automatically generated. Lots of tables so i do not
attached their structure.
It should be easy to find the problem.
Thanks in advance

Suha

Browse pgsql-general by date

  From Date Subject
Next Message johnf 2009-05-28 13:25:22 ubuntu 9.04 and auto-start
Previous Message Grzegorz Jaśkiewicz 2009-05-28 12:41:26 Re: \dt+ on 8.4