Tom, you are so eagle eyed - On Mon, Mar 8, 2021 at 8:53 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
> Alexander Farber <alexander.far...@gmail.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, " + > > thank you and sorry for my silly mistake