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

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: (view raw, whole thread or download thread mbox)
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.


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

Many thanks,


In response to

pdxpug by date

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

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