[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] plpgsql and control structures
From:       Nick Boutelier <nboutelier () gmail ! com>
Date:       2009-01-30 22:08:19
Message-ID: 7827ee3c-d51d-4858-abc1-eb4b36025aed () y23g2000pre ! googlegroups ! com
[Download RAW message or body]

I noticed that if I use...

IF (TG_OP = 'DELETE' AND OLD.myColumn) THEN
  -- Do something
END IF;

when an insert happens, I get an error that 'OLD' has not been
assigned. I would of thought that the control structure would just
ignored the rest of the 'if' statement if the first part (TG_OP) was
false.

Does this mean I have to branch out my control structures if I want
better speed? If the first part of the 'if' is rarely true, then I
might as well put the second control within the first.

-Nick

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]