Re: [GENERAL] Functions that return both Output Parameters and recordsets

RETURNS SETOF record AS $BODY$ TotalRecords := 10; TotalPages := 1; FOR myRecord IN SELECT cols FROM searchResults LOOP RETURN NEXT myRecord; END LOOP; Thanks, __________ Jeremy Nix Senior Application Developer Southwest Financial Services,

[GENERAL] Functions that return both Output Parameters and recordsets

Is this possible? I'm attempting to create a function like this and I'm getting the following error: ERROR: RETURN NEXT cannot have a parameter in function with OUT parameters at or near "myRecord". -- __________ Jeremy Nix Senior Application