function_in_select_constant_withfunc2_8.ans 646 字节
Newer Older
1 2 3 4 5 6 7
-- @description function_in_select_constant_withfunc2_8.sql
-- @db_name functionproperty
-- @author tungs1
-- @modified 2013-04-03 12:00:00
-- @created 2013-04-03 12:00:00
-- @tags functionProperties
SELECT func1_nosql_vol(func2_mod_int_vol(5)) FROM foo order by 1; 
8
psql:/data/tungs1_cdbfast/tinc/private/balasr3/tincrepo/functionProperty/sql/function_in_select_constant_withfunc2_8.sql:7: ERROR:  function cannot execute on segment because it issues a non-SELECT statement  (seg1 slice1 rh55-qavm20:40501 pid=19369)
9 10 11
DETAIL:  
	 SQL statement "UPDATE bar SET d = d+1 WHERE c =  $1 "
PL/pgSQL function "func2_mod_int_vol" line 2 at SQL statement