Re: Stored function RETURNS table, but in some cases columns are missing - should I set them to NULL?

Tom, you are so eagle eyed -

On Mon, Mar 8, 2021 at 8:53 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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, " +
>
>
thank you and sorry for my silly mistake