Tom, you are so eagle eyed -
On Mon, Mar 8, 2021 at 8:53 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Alexander Farber <alexander.farber@xxxxxxxxx> writes:
> However there are cases, when I only have the out_gid value, I do not want
> to return any other values.
> My question is: do I have to set the other OUT params explicitly to NULL?
plpgsql initializes them to null by default, I believe, just like ordinary
local variables.
> org.postgresql.util.PSQLException: ERROR: column "out_uid" does not exist|
This isn't related to what your function does internally.
I think the issue is you renamed out_uid to uid in your SELECT:
> String SQL_JOIN_GAME =
> "SELECT " +
> "out_uid AS uid, " +
thank you and sorry for my silly mistake
