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
