While reading celko's SQL puzzles (second edition) i followed a reference to
http://www.dbmsmag.com/9801d06.html.
There is a puzzle that counts items in boxes.
When i try to run the proposed solution on PG 8.1.5, PG says: ERROR: column reference
"qty" is ambiguous
apparently the variable declaration used in the solution is not proper for
PostgreSQL. Is there a way to solve this puzzle in PostgreSQL?
/stig
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
