Re: [SQL] 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ý:[EMAIL PROTECTED] > > I have a

[SQL] 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

Re: [SQL] interval +variable

+ '1 days'::interval ""Fatih Cerit"" <[EMAIL PROTECTED]>, haber iletisinde þunlarý yazdý:[EMAIL PROTECTED] > Dear all > > Is there anyone at there who knows howto use dateadd in pgsql. I have a > problem in my function that is like this ; > > Select into futuredate now() + interval '30 days'; <

[SQL] 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

[SQL] triggers

update trigger working on same table??? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]