From: | Don Y <pgsql(at)DakotaCom(dot)Net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | ISSTRICT behavior |
Date: | 2006-05-04 06:02:26 |
Message-ID: | 445998F2.7090304@DakotaCom.Net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Is there any way of mimicking the IS STRICT behavior
*without* declaring the function as "STRICT"?
E.g., I could use PG_ARGISNULL() to check for invocation
with a NULL argument. But, the function has already been
invoked at that point. I.e. I still have to *return*
something -- which might be used as an argument to some
other function, etc.
Or, is there some other way of aborting the function
invocation (e.g., signal an ERROR, etc.)?
Lastly, am I correct in assuming that the STRICT
modifier only protect a function from being invoked
with a NULL _from_the_SQL_interface? I.e. does it
also protect the function from being invoked from
PL/pgsql? (I'm sure it does NOT protect from a
deliberate invocation from a C language function, etc.)
(sigh) Sorry to be picking nits. I'm just trying to
sort out how to protect against folks making careless
mistakes in the future (e.g., forgetting STRICT in
the function declarations when adding a function to
a database, etc)
Thanks!
--don
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-04 06:09:20 | Re: ISSTRICT behavior |
Previous Message | carlosreimer | 2006-05-04 03:51:42 | pg_dumpall error |