Re: PL/pgSQL evaluation order - Mailing list pgsql-sql

From Mark Volpe
Subject Re: PL/pgSQL evaluation order
Date
Msg-id 3989E9A4.DE98D574@epamail.epa.gov
Whole thread Raw
In response to PL/pgSQL evaluation order  (Mark Volpe <volpe.mark@epamail.epa.gov>)
List pgsql-sql
Doesn't seem like a bad idea. I did find a better workaround, though -

cond:=TG_OP=''INSERT'';
IF cond=FALSE THENcond:=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?
>


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: A question about indexes...
Next
From:
Date:
Subject: Recursive SQL