Re: Question about STRICT

From: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
To: Greg Stark <stark(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Question about STRICT
Date: 2009-06-03 10:20:55
Message-ID: 4A264E87.9040905@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark wrote:
> On Wed, Jun 3, 2009 at 11:04 AM, Gevik Babakhani <pgdev(at)xs4all(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Markus Wanner 2009-06-03 11:10:04 Re: PostgreSQL Developer meeting minutes up
Previous Message Greg Stark 2009-06-03 10:15:52 Re: Question about STRICT