Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pdxpug by date

Next:From: Rich ShepardDate: 2011-02-04 21:02:45
Subject: Re: UPDATE Syntax Error
Previous:From: Tim BruceDate: 2011-02-04 20:52:07
Subject: Re: UPDATE Syntax Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group