Rafal Pietrak <[EMAIL PROTECTED]> writes: > CREATE FUNCTION new_user (text,text) RETURNS SETOF people AS $$ > CREATE ROLE $1 PASSWORD $2; > SELECT CASE WHEN $2 is not null THEN ROW($1, null, null, null)::people > ELSE null::ludzie END > $$ language sql;
> "ERROR: function returning set of rows cannot return null value" If you want to return no rows, then return no rows. Something like SELECT ROW($1, null, null, null)::people WHERE $2 is not null; regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings