On 11/13/05, Robert Treat <[EMAIL PROTECTED]> wrote: > On Saturday 12 November 2005 04:06, Matteo Beccati wrote: > > | 1 | 1 | NULL | > Wow, that seems ugly.... maybe there's a reason for it, but I'm not sure we > could deviate from my$ql's behavior on this even if we wanted... they are the > "standard" here.
I don't think that's ugly, I think that's exactly working as advertised. Replace behaves exactly like deleting the record with the matching primary key and inserting the provided input. ... not merging together old data with new. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match