views:

39

answers:

2

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