Re: [SQL] Problems Testing User-Defined Function

2006-06-10 Thread Tom Lane
"Rommel the iCeMAn" <[EMAIL PROTECTED]> writes: > Thanks for the input so far. No it wasn't a direct paste, what I did in fact > type was SELECT sp_insert_manifest('me', '[EMAIL PROTECTED]', '[EMAIL > PROTECTED]', > 'test.txt', NULL, '2006/06/09'). The error message said something like > function

Re: [SQL] Problems Testing User-Defined Function

2006-06-09 Thread Rommel the iCeMAn
Hi guys, Thanks for the input so far. No it wasn't a direct paste, what I did in fact type was SELECT sp_insert_manifest('me', '[EMAIL PROTECTED]', '[EMAIL PROTECTED]', 'test.txt', NULL, '2006/06/09'). The error message said something like function sp_insert_manifest(character varying, character

Re: [SQL] Problems Testing User-Defined Function

2006-06-09 Thread Jim Buttafuoco
You will have to use the "CALLED ON NULL INPUT" option to "create function" (Postgresql 8.1, I don't know about other versions) if you expect NULL arguments. Jim -- Original Message --- From: "Rommel the iCeMAn" <[EMAIL PROTECTED]> To: "PostgreSQL SQL Mailing List" Sent: Fri,

Re: [SQL] Problems Testing User-Defined Function

2006-06-09 Thread George Weaver
- Original Message - From: "Rommel the iCeMAn" <[EMAIL PROTECTED]> I am trying to pass the following values to the function but I have been so far unsuccessful. What error message are you receiving? SELECT sp_insert_manifest('me', [EMAIL PROTECTED]', '[EMAIL PROTECTED]', 'test.t