Re: Function not RAISE NOTICE if a parameter is NULL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andre Lopes <lopes80andre(at)gmail(dot)com>
Cc: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: Function not RAISE NOTICE if a parameter is NULL
Date: 2010-05-04 22:23:30
Message-ID: 21427.1273011810@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andre Lopes <lopes80andre(at)gmail(dot)com> writes:
> If I use NULL in any parameter the function does not RAISE any NOTICE. I
> can't pass NULL values in parameters?

Sure you can. Maybe you declared the function STRICT? That means to
not call it for a NULL.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-05-04 22:40:42 Re: Please help me debug regular segfaults on 8.3.10
Previous Message Andre Lopes 2010-05-04 22:09:52 Function not RAISE NOTICE if a parameter is NULL