Re: Using UPDATE ... RETURNING in a custom SQL function, which RETURNS integer - Mailing list pgsql-general

From rob stone
Subject Re: Using UPDATE ... RETURNING in a custom SQL function, which RETURNS integer
Date
Msg-id 1480681236.5634.1.camel@gmail.com
Whole thread Raw
In response to Using UPDATE ... RETURNING in a custom SQL function, which RETURNS integer  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general

> And finally here is the failing usage of the function :
>
> words=> SELECT uid FROM words_unban_user(1);
> ERROR:  column "uid" does not exist
> LINE 1: SELECT uid FROM words_unban_user(1);
>                ^
>
>
Shouldn't you be doing:-

SELECT words_unban_user(1);




pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Using UPDATE ... RETURNING in a custom SQL function, which RETURNS integer
Next
From: Alexander Farber
Date:
Subject: Re: Using UPDATE ... RETURNING in a custom SQL function, which RETURNS integer