628 

   628 Temporary constant table

   629 ========================

   630 

   631 Standard SQL syntax::

   632 

   633   SELECT 1 AS num, 'a' AS str

   634   UNION ALL SELECT 2, 'b'

   635   UNION ALL SELECT 3, 'c';

   636 

   637 Postgre extension::

   638 

   639   SELECT num, str FROM (

   640     VALUES (1, 'a'), (2, 'b'), (3, 'c')) AS tbl(num, str);

   641 

   642 To generate table::

   643 

   644   SELECT val FROM generate_series(1, 10) val;

   645