EXECUTE INTO on 8.2 - Mailing list pgsql-general

From Jon Asher
Subject EXECUTE INTO on 8.2
Date
Msg-id d24c7af0612131036r51e02751rb45bdc52ae95188b@mail.gmail.com
Whole thread Raw
Responses Re: EXECUTE INTO on 8.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm seeing some strange behavior with the following code.  It compiles and runs but returns an error on the Execute statement:
List index out of bounds(0)
 
DECLARE
   srec record;
   v_formula varchar;
   v_result varchar;
 
BEGIN
   v_formula = 'select 4 as val';
   EXECUTE v_formula INTO srec;
END;
 
However, the old school version runs w/no problem:
 
BEGIN
   v_formula = 'select 4 as val';
  
   FOR srec IN EXECUTE v_formula LOOP
       v_result = srec.val;
   END LOOP;
END;
 
Any idea why the new syntax isn't working?  (I'm running 8.2 on a Windows dev box.)

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pltcl error - could not create "normal" interpreter
Next
From: Bill Moran
Date:
Subject: Re: MySQL drops support for most distributions