Re: [SQL] a celko-puzzle from long time ago

2006-11-06 Thread George Pavlov
Jr > Sent: Monday, November 06, 2006 11:55 AM > To: stig erikson; pgsql-sql@postgresql.org > Subject: Re: [SQL] a celko-puzzle from long time ago > > > While reading celko's SQL puzzles (second edition) i > followed a reference to > > http://www.dbmsmag.com/9801d06.h

Re: [SQL] a celko-puzzle from long time ago

2006-11-06 Thread Richard Broersma Jr
> 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 t

[SQL] a celko-puzzle from long time ago

2006-11-06 Thread stig erikson
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 decl