Don't know if this will get attached to the conversation, but here is how I have dealt with this.
insert into names (name, created_date) values ($1, default); update names n set created_date = coalesce($2, n.craeted_date) where name = $1; So basically insert all of your non-defaulted columns with the primary key. This will put the defaults into the table. Then update with coalesce the values passed into the proc. The coalesce will use the parameter unless it is NULL. If it is NULL it will use the default from the table. This is inefficient since it will version the row in the table for each call to the proc. Brent DeSpain
