Error in select - Mailing list pgsql-general

From Carmen Gloria Sepulveda Dedes
Subject Error in select
Date
Msg-id 3FCCE180.2017E060@atichile.com
Whole thread Raw
Responses Re: Error in select
List 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


pgsql-general by date:

Previous
From: "Keith C. Perry"
Date:
Subject: Re: pg_dump on one user not whole database
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Invalid page header in block