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.
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general