-- @description function_in_from_subqry_withfunc2_7.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_nosql_vol(func2_read_int_stb(5))) r order by 1,2,3; 
 a  | b  | func1_nosql_vol 
----+----+-----------------
  1 |  2 |               7
  2 |  3 |               7
  3 |  4 |               7
  4 |  5 |               7
  5 |  6 |               7
  6 |  7 |               7
  7 |  8 |               7
  8 |  9 |               7
  9 | 10 |               7
 10 | 11 |               7
(10 rows)