Re: SQL spec/implementation question: UPDATE

From: Kevin Hunter <hunteke(at)earlham(dot)edu>
To: andy <andy(at)squeakycode(dot)net>
Cc: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL spec/implementation question: UPDATE
Date: 2007-10-22 05:51:33
Message-ID: 471C3A65.6080902@earlham.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Hunter 2007-10-22 05:51:44 Re: SQL spec/implementation question: UPDATE
Previous Message Ow Mun Heng 2007-10-22 05:37:09 Re: looking for some real world performance numbers