not returning anything from postgresql function?

Posted by netllama on Stack Overflow See other posts from Stack Overflow or by netllama
Published on 2010-05-01T03:08:50Z Indexed on 2010/05/01 3:17 UTC
Read the original article Hit count: 303

Filed under:
|

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?

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about function