| 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: | Whole Thread | Raw Message | 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 |