Re: [BUGS] [GENERAL] PL/pgSQL Function Help

2006-01-03 Thread Tom Lane
I wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: >> I get an assertion failure if rec is declared as a record but not >> if it's declared as a test_type. And only in 8.0.5, not in 8.1.1 >> or 8.2devel. > I find that the lack of an assertion failure in 8.1 is a happenstance of > unrelated chang

Re: [BUGS] [GENERAL] PL/pgSQL Function Help

2005-12-16 Thread Jim C. Nasby
On Fri, Dec 16, 2005 at 05:10:11PM -0500, Tom Lane wrote: > We need to fix plpgsql to ensure that what it returns is of the expected > record type. Should a test be added to regression for this? That's something I should be able to do... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PRO

Re: [BUGS] [GENERAL] PL/pgSQL Function Help

2005-12-16 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > Here's a simplified version: > CREATE TYPE test_type AS (x integer); > CREATE FUNCTION test() RETURNS test_type AS $$ > DECLARE > rec record; > BEGIN > SELECT INTO rec 1; > RETURN rec; > END; > $$ LANGUAGE plpgsql; > SELECT test(); > I g