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
