Re: Pl/pgsql functions causing crashes in 8.2.2

Reading the post again I caught a typo in my query.  I had been playing
with variations of this test to try and get it working, but I have had no
success with any combination as long as it returns this kind of type.

I was comparing integers to uniqueidentiers, which actually works, but is
unrelated to the issue.

Should be:

> CREATE OR REPLACE FUNCTION test.break_guid (numlower integer, numupper
> integer) RETURNS SETOF test.guid_plus AS
> $$
> DECLARE
>     x RECORD;
>     gplus_ret test.guid_plus;
> BEGIN
>     FOR x IN SELECT id,num FROM test.guid_table WHERE num > numlower AND
num
> < numupper LOOP
>         gplus_ret :=
> (x.id::uniqueidentifier,x.num::integer)::test.guid_plus;
>         -- I usually do the following: (but tried above with same result)
>         --   gplus_ret := (x.id,x.num);
>         RETURN NEXT gplus_ret;
>     END LOOP;
>     RETURN;
> END;
> $$ LANGUAGE plpgsql;


Jonathan Gray
jon5pg@streamy.com