X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D02549FA5F8 for ; Fri, 9 Jun 2006 22:21:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 36831-10 for ; Fri, 9 Jun 2006 22:21:53 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.228]) by postgresql.org (Postfix) with ESMTP id 3D2C09FA38F for ; Fri, 9 Jun 2006 22:21:52 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 69so943226wri for ; Fri, 09 Jun 2006 18:21:50 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:x-mimeole:in-reply-to:thread-index; b=W0k81OeTfTNONxpSDVtDyK/VQB9veN8wmY1U4o1vvdv7EHUgdB3O4BWvMnxWP3BqndlJ6f6Du4U+6s1x/PjXbMSAdzlux3HWuMMkLgAats/nFNN7sOcLEKXEHRBIHXSXQ960MqDBnemU+J1XeDkkZaMk7BIvFBLFiMg+IMZocm0= Received: by 10.54.139.10 with SMTP id m10mr3627835wrd; Fri, 09 Jun 2006 18:21:50 -0700 (PDT) Received: from mis06 ( [69.73.205.186]) by mx.gmail.com with ESMTP id 7sm3783186wrl.2006.06.09.18.21.49; Fri, 09 Jun 2006 18:21:50 -0700 (PDT) From: "Rommel the iCeMAn" To: "PostgreSQL SQL Mailing List" Subject: Re: Problems Testing User-Defined Function Date: Fri, 9 Jun 2006 21:19:51 -0400 Message-ID: <000f01c68c2c$02384690$111117ac@theport.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 In-Reply-To: <008001c68c03$f9aa5cc0$6400a8c0@Dell4500> Thread-Index: AcaMA/YzqU4SM4aGRwy6nL2phGx++gAJs6og X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/112 X-Sequence-Number: 25348 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', 'me@you.com', 'me@you.com', 'test.txt', NULL, '2006/06/09'). The error message said something like function sp_insert_manifest(character varying, character varying, character varying, character varying, "unknown", timestamp) does not exist. It seems NOT to like my NULL parameter. I'll investigate the "CALLED ON NULL INPUT" option that Jim suggested. Thanks again, Rommel Edwards.