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 8189D9FA5DD for ; Fri, 9 Jun 2006 17:03:30 -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 80787-05 for ; Fri, 9 Jun 2006 17:03:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.239]) by postgresql.org (Postfix) with ESMTP id 745FD9FA1A8 for ; Fri, 9 Jun 2006 17:03:20 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 69so901288wri for ; Fri, 09 Jun 2006 13:03:17 -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:thread-index:x-mimeole; b=iW0Tt/TwMMYDgfAUOJkOYyWYDwU2fiatcjvFkUEhSmR6ZXhPTrWP/JxrHtybAKpyQYVBd0gCT10smahPnd6P5CjWtz+WSEvFA0lPHRKT3ynlzfoDu2NH6yMj7W0FAlqf+Mi6YOojJ+Y9lsrCFFdvenwTxFpgnlvsMpy4dGV6GLg= Received: by 10.54.89.9 with SMTP id m9mr3383096wrb; Fri, 09 Jun 2006 13:03:17 -0700 (PDT) Received: from mis06 ( [205.214.220.146]) by mx.gmail.com with ESMTP id 13sm1529263wrl.2006.06.09.13.03.15; Fri, 09 Jun 2006 13:03:16 -0700 (PDT) From: "Rommel the iCeMAn" To: "PostgreSQL SQL Mailing List" Subject: Problems Testing User-Defined Function Date: Fri, 9 Jun 2006 16:01:26 -0400 Message-ID: <000001c68bff$828b5ad0$1264a8c0@theport.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcaL/3rHMwv5BxxaQGmokoQaEKi7rw== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/109 X-Sequence-Number: 25345 Hi list, I'm a newbie and I have a problem. I've defined the following function using pgAdmin but I am clueless as to how I can test it. I will eventually be calling this function from a .NET application but I want to test it using raw SQL first. Here's the function definition: CREATE OR REPLACE FUNCTION sp_insert_manifest(_sender varchar(255), _sender_email varchar(255), _reply_to varchar(255), _filename varchar(255), _file oid, _datetime_sent timestamp) RETURNS integer AS $$ -- blah blah -- $$ LANGUAGE plpgsql; I am trying to pass the following values to the function but I have been so far unsuccessful. SELECT sp_insert_manifest('me', me@you.com', 'me@you.com', 'test.txt', NULL, '2006/06/09') Can anyone help me here? Thanks, Rommel the iCeMAn.