Re: returning setof varchar

Scott Schulthess wrote:
> How do I get this to work?

> for r in SELECT distinct(substring(drgtitle, 1, 1)) as text from
> stockdrgmeta where state ilike  '%' || $1 || '%'

>
> loop variable of loop over rows must be record or row variable at or
> near "LOOP" at character 218


DECLARE
    r RECORD;
BEGIN
    FOR r IN ...
        RETURN NEXT r.text

--
   Richard Huxton
   Archonet Ltd