Re: [SQL] How to simulate (run) the function

2009-09-04 Thread Scott Marlowe 
On Fri, Sep 4, 2009 at 8:43 PM, bilal ghayyadbilmar...@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 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.

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

[SQL] How to simulate (run) the function

2009-09-04 Thread bilal ghayyad 
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


  

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql