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
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 |