DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=GGkpCDkbpQWaMtDLVpT75+speB+QvAbrbWaBoskmq/IRUsiyGNSNx47tNjcoKhUyj5Qh4q0ca8d+HA91MiyS/NQTJYcYO4vRSluD1DB+vmpHlik7dY3JRLRN05e/eNgI4cJ0chpI6MhZL8oBpF08wE9R0Gz7ahutxW1zfes4ikU=;
Date: Wed, 2 May 2007 17:17:07 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Joe Celko's method to "generate_series" not working?
To: SQL Postgresql List <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <649296.88043.qm@web31815.mail.mud.yahoo.com>

Well, I am about a book and a-half away from reading all of the Joe Celko's books that I know of.
I just came across an nice looking way to generate a series using a set oriented construct. 
However, I am not able to get it to work in PostgreSQL.

The method follows from the SQL Programming Style p.164:

SELECT hundred * 100 + ten * 10 + unit + 1 
  FROM	( VALUES( 0, 1, 2, 3, 4, 5, 6, 7, 8, 9)) AS Units( unit ) 
	CROSS JOIN 
	( VALUES( 0, 1, 2, 3, 4, 5, 6, 7, 8, 9)) AS Tens( ten )
	CROSS JOIN
	( VALUES( 0, 1, 2, 3, 4, 5, 6, 7, 8, 9)) AS Hundreds( hundred );

but I am getting:

 ?column?
----------
        1
(1 row)

which isn't close to the 1000 rows that I am expecting.  

Is Mr. Celko mistaken?  Does anyone know if PostgreSQL has any functions that I can turn these
VALUES rows into columns so that the CROSS JOINS will work?   

Regards,
Richard Broersma Jr.