Received: from nts1.rtp.epa.gov (nts1.rtp.epa.gov [134.67.208.208]) by hub.org (8.10.1/8.10.1) with ESMTP id e73LrLG01767 for ; Thu, 3 Aug 2000 17:53:21 -0400 (EDT) Received: from epamail.epa.gov (IDENT:mvs@wolfpack.rtpnc.epa.gov [134.67.139.59]) by nts1.rtp.epa.gov (8.9.3/8.9.3) with ESMTP id RAA08288; Thu, 3 Aug 2000 17:56:30 -0400 (EDT) Message-ID: <3989E9A4.DE98D574@epamail.epa.gov> Date: Thu, 03 Aug 2000 17:52:36 -0400 From: Mark Volpe X-Mailer: Mozilla 4.74 [en] (X11; U; Linux 2.2.14-15mdk i586) X-Accept-Language: en MIME-Version: 1.0 To: Jan Wieck CC: pgsql-sql@postgresql.org Subject: Re: PL/pgSQL evaluation order References: <200008032116.XAA06822@jupiter.greatbridge.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/32 Doesn't seem like a bad idea. I did find a better workaround, though - cond:=TG_OP=''INSERT''; IF cond=FALSE THEN cond:=NEW.ip!=OLD.ip; END IF; IF cond=TRUE ... so it won't kill me. Anyway, I've been totally impressed with the 7.0 release. I'm building the EPA IP address registration system on top of it. My favorite feature is the support for REFERENCES (though I had to hack the code a bit to get around a permissions problem). Thanks, Mark Jan Wieck wrote: > > Maybe we should change the treatment of unassigned rowtype > values that any reference to it holds the NULL value? >