subject:"\[HACKERS\] INOUT\/OUT problems with IMMUTABLE"

Re: [HACKERS] INOUT/OUT problems with IMMUTABLE

2005-05-27 Thread Tom Lane

Michael Fuhr <[EMAIL PROTECTED]> writes: > Is the following behavior intended? Nope. Thanks for the report ;-) regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://ar

[HACKERS] INOUT/OUT problems with IMMUTABLE

2005-05-27 Thread Michael Fuhr

Is the following behavior intended? CREATE FUNCTION foo(INOUT x integer, INOUT y integer) AS $$ BEGIN x := x * 10; y := y * 10; END; $$ LANGUAGE plpgsql; SELECT * FROM foo(1, 2); x | y + 10 | 20 (1 row) ALTER FUNCTION foo(integer, integer) IMMUTABLE; SELECT * FROM foo(1, 2)