> 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?
I believe that qty is a parameter variable that must first be set in psql.
I've seen some thread
in various lists that describe how to set parameter variables before executing
a query that uses
them.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
