Alexander Farber <alexander(dot)farber(at)gmail(dot)com> 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, " +
regards, tom lane