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, " + regards, tom lane
