Re: SQL plan in functions

On 18/12/2008 12:40, Julius Tuskenis wrote:
> Yes, Raymond - I know how to return record set in function using FOR,
> but since version 8.3 there is a option - using RETURN QUERY SELECT
> something FROM somewhere;. So if it works for SELECT why should it not
> work for EXECUTE ?

Oh - I didn't know about that....so I'm afraid I don't know why it's
causing a problem for you.... :-)

Ray.

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