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

--- Richard Broersma Jr <rabroersma(at)yahoo(dot)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.