From: stig erikson <stigerikson_nospam_@yahoo.se>
To: pgsql-sql@postgresql.org
Subject: a celko-puzzle from long time ago
Date: Sun, 05 Nov 2006 19:46:30 +0100
Message-ID: <eilbl4$749$1@floppy.pyrenet.fr> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: stigerikson_nospam_@yahoo.se
Subject: Re: a celko-puzzle from long time ago
In-Reply-To: <eilbl4$749$1@floppy.pyrenet.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox