Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 8780C632DFB for ; Fri, 4 Sep 2009 23:43:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 01246-10 for ; Sat, 5 Sep 2009 02:42:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web53910.mail.re2.yahoo.com (web53910.mail.re2.yahoo.com [206.190.36.220]) by mail.postgresql.org (Postfix) with SMTP id 8C60C632AC7 for ; Fri, 4 Sep 2009 23:43:08 -0300 (ADT) Received: (qmail 80017 invoked by uid 60001); 5 Sep 2009 02:43:06 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1252118586; bh=+8ZxjgYgxEGGJzgPSj5Ywcn1jeZ91DJAJU5oUV5ejVI=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=AAiCz7atq+d6J+6Q1NJVXoLAnZXs4dyqUzsHe4lysnsezFH8Ho8gsF5KWvjHpqawPlHJ+N1OmjY9ZAF++LndkomtydHzpTZTd0PzRbOzgNVlxXERGjOS3pxhB4Gmopt47c012MSXhM1hMHWFG6sPltpRRb7rW/Ke0B4OhKX3B5U= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=M/71NjXK2Bvd5xyNWpJzsUdrdx4UOpwm8MtxQGeQiP3vKt4DFqIdA9bWNfMXuvo4Jikqddhz/RbqnT71aPsholOJxxBRMA8O1bHAhERjFvl7g7wti59RTTMGl4A/JIiiXbuSFutdgqqcmKrZ3KKI8aMbun7d0chPb+rZD3xYqjo=; Message-ID: <711886.79685.qm@web53910.mail.re2.yahoo.com> X-YMail-OSG: BdfCApoVM1lPs2EAvgzzMO61.o0_.EYooVOspLuMT0kxN9FQc8jizumrGfLDNX.W4ndiI4OU5.MwQnEqmRAz3Xt_DHiWXw9YE03wX.WzyViKXgZ3OMjIXGEPhslfX_qcuNr2XVXR3sRPFBOGYLBkd4lm3kZjOkkzdbxFr60G6ztKdrvJe0UfIEHeJlVBeks.qq0aB9lgn5QP2gsdQLZCoUwD33JK0n.H.EA_Vb0n6VmAboBkP_HhnblLCNuyhgB7lnpboZ0dl2rutpkjAcWeSSjRjWZKl6VA2qv9.oNAeuZGmi8GM6UeGHFzgUaY7R4zfdTD36dTlPMcF9DkLt14WRLrKV2OxAktNt2O Received: from [62.150.150.85] by web53910.mail.re2.yahoo.com via HTTP; Fri, 04 Sep 2009 19:43:06 PDT X-Mailer: YahooMailClassic/6.1.2 YahooMailWebService/0.7.338.2 Date: Fri, 4 Sep 2009 19:43:06 -0700 (PDT) From: bilal ghayyad Subject: How to simulate (run) the function To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.463 tagged_above=-10 required=5 tests=AWL=0.277, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 200909/27 X-Sequence-Number: 33092 Hello; I have an SQL function and I need to know how to simulate it (calling it and pass for it the argument and see what the value it returns), HOW? Can I do this from the pgAdminIII GUI or from the CLI? This method help to check that the function is working fine specially if it will be called using the a specific username which has access to that function. Any advise? Regards Bilal