Re: SQL plan in functions

On 18/12/2008 12:12, Julius Tuskenis wrote:

> While experimenting I found that if I wright FOR rec IN EXECUTE 'my sql'
> LOOP ...... its OK, but If I wright RETURN QUERY EXECUTE 'my sql' I get
> syntax error. Is it a bug?

No, it's a syntax error. :-)

You need to do something like this to return the rows from the query:

FOR rec in EXECUTE 'your sql here'
LOOP
RETURN NEXT rec;
END LOOP;

RETURN; -- exits from the function.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------