Re: [GENERAL] diff value retuns, debug mode and play mode

it is about null problem declare res numeric(15,2); _pida integer[4]; < Problem is here must be ---> pida integer[4]='{}'; _pid integer; _rec record; ...... "ALÝ ÇELÝK" <[EMAIL PROTECTED]>, haber iletisinde þunlarý yazd

[GENERAL] more execution time

why this query needs more time? Its very slow thx //QUERY select coalesce(personaldetails.masterid::numeric,personaldetails.id) + (coalesce(personaldetails.id::numeric,0)/100) as sorting, floor(coalesce(personaldetails.masterid::numeric,personaldet

[GENERAL] diff value retuns, debug mode and play mode

I have a postgresql function at the bottom , when i run at EMS POSTGRESQL debug mode with F8 step by step. Its work great but when i use with play button it returns null what is the different about debug mode and run mode. BEST REGARDS. CREATE OR REPLACE FUNCTION "public"."allocatedamount" (v