Re: Null function parameters

From: tolik(at)aaanet(dot)ru (Anatoly K(dot) Lasareff)
To: "postgresql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Null function parameters
Date: 2000-08-24 06:39:54
Message-ID: 864s4b40xx.fsf@tolikus.hq.aaanet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>>>>> "TL" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

TL> 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.

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

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

Thank you. I'll be waiting :)

--
Anatoly K. Lasareff Email: tolik(at)aaanet(dot)ru

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message hlefebvre 2000-08-24 09:36:01 Re: Create table in functions
Previous Message Hiroshi Inoue 2000-08-24 06:14:02 RE: Create table in functions