Is it possible for a PostgreSQL plpgsql function to not return anything? I've created a function, and I don't need it to return anything at all, as it performs a complex SQL query, and inserts the results of that query into another table (SELECT INTO ....). Thus, I have no need or interest in having the function return any output or value. Unfortunately, when I try to omit the RETURN clause of the function declaration, I can't create the function. Is it possible for a PostgreSQL plpgsql function to not return anything?
A:
No, it must at least return null
. From the PostgreSQL documentation:
A trigger function must return either NULL or a record/row value having exactly the structure of the table the trigger was fired for.
Lars Andren
2010-05-01 03:21:45