Michael Lewis <mlewis@xxxxxxxxxxx> writes: > Thanks sir. It seems unfortunate that there is not a way to indicate > absence of the third parameter if I need to set a value for the fourth > parameter. The way to do that is to use named parameters and the associated call syntax, ie something like select myfunc(param1 => 42, param3 => 99); regards, tom lane