Re: [GENERAL] Altering built-in functions cast

2005-08-26 Thread Matt A.
Thank you so much for the reply. I inserted the function as you said in pgsql. I tried testing it and got... PERFECT RESULTS! THAAANKKK YOUUU! *kisses feet* j/k But honestly, Thank you very much. You saved me from suicide. --- Richard Huxton wrote: > Mat

Re: [GENERAL] Altering built-in functions cast

2005-08-26 Thread Richard Huxton
Matt A. wrote: Anyone know how I could alter the cast of the nullif() function directly to return INT? We use NULLIF() for adding [1|0|null] according to the evalution of nullif('x','') into integer columns. Where x is an integer and sometimes a empty string, which if it's an empty string (x='')

[GENERAL] Altering built-in functions cast

2005-08-25 Thread Matt A.
Anyone know how I could alter the cast of the nullif() function directly to return INT? We use NULLIF() for adding [1|0|null] according to the evalution of nullif('x','') into integer columns. Where x is an integer and sometimes a empty string, which if it's an empty string (x='') then we add NULL