Hi, According to the docs, the DEFAULT keyword lets you explicitly insert a field's default value in an INSERT statement.
>From a db function, I'd like to force the use of default when an input parameter is null. This syntax looks correct but fails to compile. Any suggestions? INSERT INTO public.test ( userid, object_id, user_notes, object_status, created_ts ) VALUES ( p_userid, p_obj_id, p_user_notes, p_obj_status, Case When p_created_ts Is Not Null Then p_created_ts Else DEFAULT End ); I tried replacing the Case statement as follows, but it fails also: Coalesce(p_created_ts, DEFAULT) Thanks