Re: Problem with records that disappear.

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with records that disappear.
Date: 2013-01-14 09:31:35
Message-ID: 50F3D077.3070309@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Condor 2013-01-14 09:34:26 Re: Problem with records that disappear.
Previous Message Hendrik Visage 2013-01-14 09:24:22 Re: Linux Distribution Preferences?