Re: UPDATE Syntax Error

From: Darrell Fuhriman <darrell(at)garnix(dot)org>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pdxpug(at)postgresql(dot)org
Subject: Re: UPDATE Syntax Error
Date: 2011-02-04 20:58:14
Message-ID: 4E4A3C34-FE9B-4BA5-9B6F-EC1252EADC46@garnix.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

> jerrittwq=# update monitor set units = 'mg/L' where units = NULL

= NULL will never return true.

You want 'where units is null'

d.

In response to

Browse pdxpug by date

  From Date Subject
Next Message Rich Shepard 2011-02-04 21:02:45 Re: UPDATE Syntax Error
Previous Message Tim Bruce 2011-02-04 20:52:07 Re: UPDATE Syntax Error