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='') then we add NULL
cause NULLIF says if '' == '' then return NULL
Just add a wrapper function:
CREATE FUNCTION nullif_always_int(text) RETURNS integer AS '
SELECT nullif($1,'''')::int;
' LANGUAGE SQL;
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
