Re: STRICT function returning a composite type - Mailing list pgsql-sql

From Tom Lane
Subject Re: STRICT function returning a composite type
Date
Msg-id 28012.1068744478@sss.pgh.pa.us
Whole thread Raw
In response to Re: STRICT function returning a composite type  ("Alexander M. Pravking" <fduch@antar.bryansk.ru>)
Responses Re: STRICT function returning a composite type  ("Alexander M. Pravking" <fduch@antar.bryansk.ru>)
List pgsql-sql
"Alexander M. Pravking" <fduch@antar.bryansk.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


pgsql-sql by date:

Previous
From: "Alexander M. Pravking"
Date:
Subject: Re: STRICT function returning a composite type
Next
From: "Alexander M. Pravking"
Date:
Subject: Re: STRICT function returning a composite type