Re: Null function parameters

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tolik(at)aaanet(dot)ru (Anatoly K(dot) Lasareff)
Cc: "Graham Vickrage" <graham(at)digitalplanit(dot)com>, "postgresql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Null function parameters
Date: 2000-08-23 14:00:59
Message-ID: 27707.967039259@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

tolik(at)aaanet(dot)ru (Anatoly K. Lasareff) writes:
> I'afraid no. My question is: if I pass one null argument into function
> then all other argumens, which are not null, became null inside
> function body.

Yes --- and not only that, but the function's result will be taken to be
null whether you want it to be or not. This has been gone over *many*
times before on this mail list, so I didn't think I needed to repeat it.

This will be fixed in 7.1 (is already fixed in current sources).

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-08-23 14:24:35 Re: Using SETOF in plpgsql function
Previous Message Andreas Tille 2000-08-23 13:53:35 Re: Date of creation and of change