From: Michael Fuhr <mike@fuhr.org>
To: Benno Pütz <puetz@mpipsykl.mpg.de>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: How to detect NULL in VarChar (C function)
Date: Thu, 13 Jan 2005 12:50:31 -0700
Message-ID: <20050113195031.GA40861@winnie.fuhr.org> (raw)
In-Reply-To: <41E6A794.6020701@mpipsykl.mpg.de>
References: <41E6A794.6020701@mpipsykl.mpg.de>
On Thu, Jan 13, 2005 at 05:53:40PM +0100, Benno Pütz wrote:
> I try to write a function that combines two varchar columns.
>
> Now the problem arose that (either) one of te columns may contain a NULL
> value, in which case the return value seems to become NULL.
What do you mean "seems" to become NULL? Is it NULL or not? You
can check with IS NULL:
SELECT foo(value1, value2) IS NULL;
> I have not been able to find a description of how to detect NULL values
> in VarChar variables passed to C-functions to catch those cases.
If you're using the version-1 calling conventions then you can use
PG_ARGISNULL(); this macro is mentioned in the "C-Language Functions"
section of the "Extending SQL" chapter in the documentation.
If you created the function as STRICT (aka RETURNS NULL ON NULL
INPUT) and any of the arguments are NULL, then the function won't
be called at all and the return value will be NULL. If you want
to handle NULL values within the function then don't declare it
STRICT.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mike@fuhr.org, puetz@mpipsykl.mpg.de
Subject: Re: How to detect NULL in VarChar (C function)
In-Reply-To: <20050113195031.GA40861@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox