Re: CASE statement and SETOF values - Mailing list pgsql-general

Am Dienstag, 25. Juli 2006 17:56 schrieben Sie:
> You could use a procedural language like plpgsql.

Ok, using the plpgsql approach I tried this:

CREATE FUNCTION my_function(int4) RETURNS SETOF int8 AS
$BODY$
DECLARE
    myrow RECORD;
BEGIN
    IF (some_condition) THEN
            FOR myrow IN SELECT ... -- some select statement
            LOOP
                RETURN NEXT myrow."foocolumn";
            END LOOP;
        ELSE
            FOR myrow IN SELECT ... -- some select statement
            LOOP
                RETURN NEXT myrow."foocolumn";
            END LOOP;
    END IF;
    RETURN;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;

But creating this function fails, because it's "missing a LOOP" statement.
What am I missing?

CU
Christian