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: (view raw, whole thread or download thread mbox)
Lists: pdxpug
> jerrittwq=# update monitor set units = 'mg/L' where units = NULL

= NULL will never return true.

You want 'where units is null'


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-2017 The PostgreSQL Global Development Group