Hi Heikki, Here you can find attached .csv semicolon separated made by :"SELECT * FROM pg_proc WHERE proname LIKE 'sp_get_league_prediction". "\df sp_get_league_prediction" is also attached.
Both functions are returning the same setof record: --------------------------- CREATE OR REPLACE FUNCTION sp_get_league_prediction(IN _id bigint, IN _rank integer, IN _log_in_expectence double precision, IN _feathers_gained integer, IN _tokens_all integer, IN _tokens_active integer, IN _score integer) RETURNS SETOF record AS $BODY$ ... --------------------------- CREATE OR REPLACE FUNCTION sp_get_league_prediction(_id bigint, _rank integer, _log_in_expectence double precision, _feathers_gained integer, _tokens_all integer, _tokens_active integer, _score integer) RETURNS SETOF record AS $BODY$ ... On Fri, May 17, 2013 at 4:11 PM, Heikki Linnakangas <hlinnakan...@vmware.com > wrote: > On 17.05.2013 13:31, > vladimir.jovanovic@aparteko.**com<vladimir.jovano...@aparteko.com>wrote: > >> I noticed that I have two functions with the same signature. >> >> sp_get_league_prediction(IN _id bigint, IN _rank integer, IN >> _log_in_expectence double precision, IN _feathers_gained integer, IN >> _tokens_all integer, IN _tokens_active integer, IN _score integer) >> >> sp_get_league_prediction(_id bigint, _rank integer, _log_in_expectence >> double precision, _feathers_gained integer, _tokens_all integer, >> _tokens_active integer, _score integer) >> > > In addition to higher-level checks, there is a unique index in the pg_proc > catalog that should not let that happen, so to be honest, I find that hard > to believe. Are you 100% they have the same signature? Are they in > different schemas, perhaps? In psql, what does "\df > sp_get_league_prediction" return? > > - Heikki > -- *Vladimir Jovanović* <http://www.aparteko.com/> http://www.aparteko.com CELL: +381 64 211 79 79 OFFICE: + 381 11 314 86 38 E-MAIL: vladimir.jovano...@aparteko.com [image: Description: cid:image001.png@01CD3D1C.7D977930] setting standards in social gaming development
<<image001.png>>
\df sp_get_league_prediction List of functions Schema | Name | Result data type | Argument data types | Type --------+--------------------------+-------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------+--------------------------------------------- -------------------------------------------------------------------------------- --------------------------+-------- public | sp_get_league_prediction | TABLE(_id bigint, _rank integer, _log_in_ex pectence double precision, _feathers_gained integer, _tokens_all integer, _token s_active integer, _score integer) | | normal public | sp_get_league_prediction | SETOF record | _id bigint, _rank integer, _log_in_expectenc e double precision, _feathers_gained integer, _tokens_all integer, _tokens_activ e integer, _score integer | normal
"proname";"pronamespace";"proowner";"prolang";"procost";"prorows";"provariadic";"proisagg";"proiswindow";"prosecdef";"proisstrict";"proretset";"provolatile";"pronargs";"pronargdefaults";"prorettype";"proargtypes";"proallargtypes";"proargmodes";"proargnames";"proargdefaults";"prosrc";"probin";"proconfig";"proacl" "sp_get_league_prediction";"2200";"10";"1120780646";"100";"1000";"0";"f";"f";"f";"f";"t";"v";"0";"0";"2249";"";"{20,23,701,23,23,23,23}";"{t,t,t,t,t,t,t}";"{_id,_rank,_log_in_expectence,_feathers_gained,_tokens_all,_tokens_active,_score}";"";" DECLARE BEGIN --body END;";"";"";"" "sp_get_league_prediction";"2200";"10";"1120780646";"100";"1000";"0";"f";"f";"f";"f";"t";"v";"7";"0";"2249";"20 23 701 23 23 23 23";"";"";"{_id,_rank,_log_in_expectence,_feathers_gained,_tokens_all,_tokens_active,_score}";"";" DECLARE BEGIN --body END;";"";"";""
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs