Re: Using UPDATE ... RETURNING in a custom SQL function, which RETURNS integer

From: rob stone <floriparob(at)gmail(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Using UPDATE ... RETURNING in a custom SQL function, which RETURNS integer
Date: 2016-12-02 12:20:36
Message-ID: 1480681236.5634.1.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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);

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2016-12-02 12:23:55 Re: Using UPDATE ... RETURNING in a custom SQL function, which RETURNS integer
Previous Message Alexander Farber 2016-12-02 09:52:03 Using UPDATE ... RETURNING in a custom SQL function, which RETURNS integer