Re: SQL spec/implementation question: UPDATE - Mailing list pgsql-general

From Kevin Hunter
Subject Re: SQL spec/implementation question: UPDATE
Date
Msg-id 471C3A65.6080902@earlham.edu
Whole thread Raw
In response to Re: SQL spec/implementation question: UPDATE  (andy <andy@squeakycode.net>)
Responses Re: SQL spec/implementation question: UPDATE  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
At 6:00p -0400 on 21 Oct 2007, andy wrote:
> I think your comparing apples and oranges.

That's why I ask the list!  To learn when I'm doing that.  ;-)

> I'll bet that mysql is
> taking a shortcut and testing the value before updating it.

Heh.  And as Tom points out downthread, that "shortcut" probably doesn't
gain anything in the long run.

Kevin

pgsql-general by date:

Previous
From: Ow Mun Heng
Date:
Subject: Re: looking for some real world performance numbers
Next
From: Kevin Hunter
Date:
Subject: Re: SQL spec/implementation question: UPDATE