Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 993C4632FFD for ; Fri, 4 Sep 2009 23:52:03 -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 02794-03 for ; Sat, 5 Sep 2009 02:51:43 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f216.google.com (mail-ew0-f216.google.com [209.85.219.216]) by mail.postgresql.org (Postfix) with ESMTP id A6B44632DFB for ; Fri, 4 Sep 2009 23:51:52 -0300 (ADT) Received: by ewy12 with SMTP id 12so1318890ewy.24 for ; Fri, 04 Sep 2009 19:51:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=a3Qp8Xxelq0AogWW8HNq5h1DxOG+yJLFNTCQihK90Zk=; b=JPktQvDQPvbwoFS3Yn6gAiFCjj1nWLk8Wl4T8TkCS8zNueQWdMest1qLn3Ud8oGLP7 7rAjPz1HM6DujvX8kard6NQZiXRSNnwOQcljN76/UfqvCgfV2lEAn5z8+0JQOPgeiCT+ YGhf1roJWYcfe5tQhPLd3Q+YJ6uLSdgLKoCCI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=GtnKVW/o4fKhMkrKF+6xXgoi04pn0mvwkEOUpQr6PThlKcFEFg/0m0tSqeqz1HaSFi +ZcX5E60FEuwsjktbwwxqwI/1xv3bARgy71UiPLdaNwtTeUPThsGt7qXbdGNu79AtcuF tzwcoboUb7Mf1bt3yfC1fzVJEW44gDPFkKSIc= MIME-Version: 1.0 Received: by 10.211.145.11 with SMTP id x11mr4223417ebn.74.1252119110418; Fri, 04 Sep 2009 19:51:50 -0700 (PDT) In-Reply-To: <711886.79685.qm@web53910.mail.re2.yahoo.com> References: <711886.79685.qm@web53910.mail.re2.yahoo.com> Date: Fri, 4 Sep 2009 20:51:50 -0600 Message-ID: Subject: Re: How to simulate (run) the function From: Scott Marlowe To: bilal ghayyad Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.318 tagged_above=-10 required=5 tests=AWL=0.281, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200909/28 X-Sequence-Number: 33093 On Fri, Sep 4, 2009 at 8:43 PM, bilal ghayyad wrote: > 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. You could call it in a transaction and roll back at the end of it.