Re: UPDATE Syntax Error

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: UPDATE Syntax Error
Date: 2011-02-04 21:02:45
Message-ID: alpine.LNX.2.00.1102041302050.9327@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

On Fri, 4 Feb 2011, Tim Bruce wrote:

> I believe you want to use units IS NULL; instead of units = NULL; in your
> WHERE clause.

Tim,

D'oh! Of course. NULLs cannot be equal to anything.

Many thanks,

Rich

In response to

Browse pdxpug by date

  From Date Subject
Next Message Darrell Fuhriman 2011-02-04 21:04:26 DBA Job Opening
Previous Message Darrell Fuhriman 2011-02-04 20:58:14 Re: UPDATE Syntax Error