On 26 Sep 2009, at 19:57, Tom Lane wrote:
I think you want INSERT ... RETURNING ... INTO some-plpgsql-variable;
regards, tom lane
On 26 Sep 2009, at 19:56, Adrian Klaver wrote:
See:
http://www.postgresql.org/docs/8.4/interactive/plpgsql-
statements.html#PLPGSQL-S
Iain Barnett 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
On Saturday 26 September 2009 11:04:42 am Iain Barnett wrote:
> 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
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'm not s
