From: Deirdre Hall <d.hall@delcan.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Stored function not accepting null value?
Date: Wed, 1 Apr 2009 14:20:55 -0500 (CDT)
Message-ID: <042101c9b2ff$7fb59120$5062140a@dc06012008> (raw)
In-Reply-To: <10034.1238612469@sss.pgh.pa.us>
References: <03f401c9b2f6$a3c2ee90$5062140a@dc06012008>
<10034.1238612469@sss.pgh.pa.us>
And that would be where I went wrong. Thanks.
DHall
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, April 01, 2009 2:01 PM
To: Deirdre Hall
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Stored function not accepting null value?
"Deirdre Hall" <d.hall@delcan.com> writes:
> I am using a stored function to determine whether a table needs an
> update or insert, based on the merge_db function in the postgres
documentation.
> (Not currently including it below because it's rather long, but other
> than the fact that it contains 27 values, it's pretty much the same as
> that
> example.)
Well, not including it is a good way to ensure that no one will really
know what the problem is ... but I wonder whether you declared the
function STRICT. That'd prevent it from being called with a NULL
argument, which seems to fit the reported behavior.
regards, tom lane
____
This communication may contain information that is confidential, privileged or subject to copyright. If you are not the intended recipient, please advise by return e-mail and delete the message and any attachments immediately without reading, copying or forwarding to others.
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-sql@postgresql.org
Cc: d.hall@delcan.com, tgl@sss.pgh.pa.us
Subject: Re: Stored function not accepting null value?
In-Reply-To: <042101c9b2ff$7fb59120$5062140a@dc06012008>
* 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