Error in select

From: Carmen Gloria Sepulveda Dedes <csepulveda(at)atichile(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Error in select
Date: 2003-12-02 19:01:20
Message-ID: 3FCCE180.2017E060@atichile.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

When I run the next query:

SELECT DATE_TRUNC('hour', TL.TAL005_DATE), TL.SRV_ID, TL.MSU_NUMBER,
DS.DESCRIPTION, DS.CALLTYPE, COUNT(*)
FROM OWNER_CATALOG.TAL005 TL,
OWNER_CATALOG.DS_AREA_CODE DS
WHERE SRV_ID = 1 AND
TAL005_DATE > to_date('01011900','ddmmyyyy') AND
DS.CODE = ( SELECT MAX(DSS.CODE)
FROM OWNER_CATALOG.DS_AREA_CODE DSS
WHERE DSS.CODE =
SUBSTR(TL.TAL005_INCLI,1,LENGTH(DSS.CODE)))
GROUP BY DATE_TRUNC('hour', TL.TAL005_DATE), TL.SRV_ID, TL.MSU_NUMBER,
DS.DESCRIPTION,DS.CALLTYPE;

I get:

ERROR: variable not found in subplan target list

This query works fine in 7.3.4, but we are migrating to 7.4 and it
doesn't work.

Some idea about the problem????

Thanks.

CG

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-12-02 19:03:06 Re: Invalid page header in block
Previous Message Keith C. Perry 2003-12-02 18:55:54 Re: pg_dump on one user not whole database