Re: PL/pgSQL question

Sebastian Ritter написа:
> Hi all,
> 
> I have a question regarding functions.  How can I return zero rows from a
> function whose return type is a table row?  I did the following test and it
> did not work as expected:
[...]


CREATE OR REPLACE FUNCTION foobar(boolean) RETURNS SETOF x AS $_$
DECLARE    res x%ROWTYPE;
BEGIN
    if $1 THEN        RETURN NEXT res;    ELSE        RETURN;    END IF;
END;$_$

LANGUAGE plpgsql;



-- 
Milen A. Radev