Re: Joe Celko's method to "generate_series" not working? - Mailing list pgsql-sql

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