Re: STRICT function returning a composite type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alexander M(dot) Pravking" <fduch(at)antar(dot)bryansk(dot)ru>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: STRICT function returning a composite type
Date: 2003-11-13 17:27:58
Message-ID: 28012.1068744478@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Alexander M. Pravking" <fduch(at)antar(dot)bryansk(dot)ru> writes:
> On Thu, Nov 13, 2003 at 05:14:27PM +0000, Richard Huxton wrote:
>> RETURNS NULL ON NULL INPUT or STRICT indicates that the function always
>> returns NULL whenever any of its arguments are NULL.

> Does "NULL result" mean an empty rowset if the function returns a record?

No, it means a null record. "Empty rowset" would apply to a function
declared to return SETOF something. (I believe that is how we
interpret the concept of strictness for functions returning sets.)

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alexander M. Pravking 2003-11-13 17:32:06 Re: STRICT function returning a composite type
Previous Message Alexander M. Pravking 2003-11-13 17:19:45 Re: STRICT function returning a composite type