Re: How to simulate (run) the function - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: How to simulate (run) the function
Date
Msg-id dcc563d10909041951w6365ee67v47138c8818dace95@mail.gmail.com
Whole thread Raw
In response to How to simulate (run) the function  (bilal ghayyad <bilmar_gh@yahoo.com>)
List pgsql-sql
On Fri, Sep 4, 2009 at 8:43 PM, bilal ghayyad<bilmar_gh@yahoo.com> 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
thevalue 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
usernamewhich has access to that function.
 

You could call it in a transaction and roll back at the end of it.


pgsql-sql by date:

Previous
From: bilal ghayyad
Date:
Subject: How to simulate (run) the function
Next
From: Frank Bax
Date:
Subject: Re: Substring