Re: minimal update

From: Decibel! <decibel(at)decibel(dot)org>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: minimal update
Date: 2007-11-12 15:54:16
Message-ID: 2287072E-57C6-4FCE-A37D-306B4DB8B20D@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Nov 2, 2007, at 10:49 AM, Andrew Dunstan wrote:
> update tname set foo = bar ... where foo is null or foo <> bar ...

FYI, you should be able to do WHERE foo IS DISTINCT FROM bar instead.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-11-12 16:02:46 Re: minimal update
Previous Message David Fetter 2007-11-12 15:51:09 Re: Simplifying Text Search