-- @description function_in_from_subqry_8.sql
-- @db_name functionproperty
-- @author tungs1
-- @modified 2013-04-03 12:00:00
-- @created 2013-04-03 12:00:00
-- @tags functionProperties
SELECT * FROM foo, (SELECT * FROM func1_sql_setint_imm(5)) r order by 1,2,3 ; 
 a  | b  | func1_sql_setint_imm 
----+----+----------------------
  1 |  2 |                    5
  1 |  2 |                    6
  1 |  2 |                    7
  1 |  2 |                    8
  1 |  2 |                    9
  1 |  2 |                   10
  2 |  3 |                    5
  2 |  3 |                    6
  2 |  3 |                    7
  2 |  3 |                    8
  2 |  3 |                    9
  2 |  3 |                   10
  3 |  4 |                    5
  3 |  4 |                    6
  3 |  4 |                    7
  3 |  4 |                    8
  3 |  4 |                    9
  3 |  4 |                   10
  4 |  5 |                    5
  4 |  5 |                    6
  4 |  5 |                    7
  4 |  5 |                    8
  4 |  5 |                    9
  4 |  5 |                   10
  5 |  6 |                    5
  5 |  6 |                    6
  5 |  6 |                    7
  5 |  6 |                    8
  5 |  6 |                    9
  5 |  6 |                   10
  6 |  7 |                    5
  6 |  7 |                    6
  6 |  7 |                    7
  6 |  7 |                    8
  6 |  7 |                    9
  6 |  7 |                   10
  7 |  8 |                    5
  7 |  8 |                    6
  7 |  8 |                    7
  7 |  8 |                    8
  7 |  8 |                    9
  7 |  8 |                   10
  8 |  9 |                    5
  8 |  9 |                    6
  8 |  9 |                    7
  8 |  9 |                    8
  8 |  9 |                    9
  8 |  9 |                   10
  9 | 10 |                    5
  9 | 10 |                    6
  9 | 10 |                    7
  9 | 10 |                    8
  9 | 10 |                    9
  9 | 10 |                   10
 10 | 11 |                    5
 10 | 11 |                    6
 10 | 11 |                    7
 10 | 11 |                    8
 10 | 11 |                    9
 10 | 11 |                   10
(60 rows)