Hi,
   To return one value not null, i've created a function :
CREATE FUNCTION isnull (int4,int4 ) RETURNS int4 AS '       BEGIN               IF ($1 IS NULL) THEN
RETURN$2;                ELSE                RETURN $1;               END IF;       END;       ' LANGUAGE 'plpgsql';
 
select isnull(my_int,0) as number, sample_id from my_table;
but I got
number  |sample_id
------+---------             |       13             |       15
What should I do to have '0' in the column 'number' instead of NULL ?
Thanks,
   nuch