That fixed it, it works now as I had hoped. Thanks again
From: Tom Lane <[EMAIL PROTECTED]>
To: "Bob Henkel" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [BUGS] BUG #1215: Call sql function from plpgsql results vary. Date: Wed, 11 Aug 2004 23:06:09 -0400
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> I was playing around seeing what new things I could do in stored procedures.
> Here is the statment I'm using to get the issue.
> select * from f_trap_error();
> I expect the above statement to alway return 1 which it does.
> The issue is I expect the trapped_error table to contain a seq id and than a
> 999 899
I think the problem is you declared f_test_sql as IMMUTABLE, which entitles the planner to execute it once and bind the result as a constant. Functions with side-effects should *never* be marked immutable (nor stable for that matter).
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
