Re: Question about STRICT - Mailing list pgsql-hackers

From Gevik Babakhani
Subject Re: Question about STRICT
Date
Msg-id 4A264E87.9040905@xs4all.nl
Whole thread Raw
In response to Re: Question about STRICT  (Greg Stark <stark@enterprisedb.com>)
Responses Re: Question about STRICT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Greg Stark wrote:
> On Wed, Jun 3, 2009 at 11:04 AM, Gevik Babakhani <pgdev@xs4all.nl> wrote:
>> The "RETURNS NULL ON NULL INPUT" is logical and does the above accordingly.
>> But when a function is STRICT you kind of expect to have an notification,
>> perhaps an error if a value for an argument is NULL.
> 
> Uhm, you might but I'm not sure why. That's not what STRICT does. It's
> a synonym for RETURNS NULL ON NULL INPUT.
> 

Perhaps it is an idea to have something like: "RAISE ERROR ON NULL INPUT"

-- 
Regards,
Gevik


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Question about STRICT
Next
From: "Markus Wanner"
Date:
Subject: Re: PostgreSQL Developer meeting minutes up