Re: INSERT... RETURNING with a function

Iain Barnett <iainspeed@gmail.com> writes:
> I've written a straightforward insert function, but using the
> RETURNING keyword for the first time. If I try running the test case
> I get the error:

> ERROR:  query has no destination for result data
> CONTEXT:  PL/pgSQL function "nonauth_users_insert_new_udf" line 7 at
> SQL statement

I think you want INSERT ... RETURNING ... INTO some-plpgsql-variable;

            regards, tom lane