Thread: Joe Celko's method to "generate_series" not working?

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.

--- Richard Broersma Jr <rabroersma@yahoo.com> wrote:

> 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?   

Having posted, I just realized what the correct syntax is:

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 )
 
ORDER BY hundred * 100 + ten * 10 + unit + 1 ;

Sorry for the noise. :o(

Regards,
Richard Broersma Jr.