[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: [HACKERS] Bad error message
From: Decibel! <decibel () decibel ! org>
Date: 2008-09-30 21:37:48
Message-ID: 4F0F56A2-8AB0-4121-BE42-1636691CE391 () decibel ! org
[Download RAW message or body]
From -HEAD:
ERROR: aggregates not allowed in WHERE clause
STATEMENT: SELECT *
FROM loans l
WHERE id IN ( SELECT max(l.id)
FROM loans
JOIN customers c ON c.id =
l.customer_id
JOIN people p ON p.id =
c.person_id
WHERE p.first_name = 'Test person'
GROUP BY l.loan_type_cd
)
;
The real issue is this:
ERROR: missing FROM-clause entry for table "l" at character 132
STATEMENT: SELECT max(l.id)
FROM loans
JOIN customers c ON
c.id = l.customer_id
JOIN people p ON
p.id = c.person_id
WHERE p.first_name =
'Test person'
GROUP BY l.loan_type_cd;
And if I change the FROM loans to be FROM loans l, the original
select does work fine.
Let me know if I need to create a full test case for this...
--
Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
["smime.p7s" (application/pkcs7-signature)]
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic