Re: Problem with records that disappear. - Mailing list pgsql-general

From John R Pierce
Subject Re: Problem with records that disappear.
Date
Msg-id 50F3D077.3070309@hogranch.com
Whole thread Raw
In response to Problem with records that disappear.  (Condor <condor@stz-bg.com>)
List pgsql-general
On 1/14/2013 12:15 AM, Condor wrote:
>   IF aid > 0 THEN
>     SELECT INTO ids id FROM table_3 WHERE x = x;
>     IF aid IS NULL THEN
> ....

oh, I see a logical error here too...   if "aid" /is/ in fact NULL then
that inner code will never be executed, because NULL can not be > 0, it
has no value.  For that matter, neither will either of the UPDATE's in
front, since id = NULL is never true.





pgsql-general by date:

Previous
From: Hendrik Visage
Date:
Subject: Re: Linux Distribution Preferences?
Next
From: Condor
Date:
Subject: Re: Problem with records that disappear.