[SQL] Stored function not accepting null value?

2009-04-01 Thread Deirdre Hall
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

Re: [SQL] Stored function not accepting null value?

2009-04-01 Thread Deirdre Hall
And that would be where I went wrong. Thanks. DHall -Original Message- From: Tom Lane [mailto:t...@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.h