pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to simulate (run) the function
2+ messages / 2 participants
[nested] [flat]
* How to simulate (run) the function
@ 2009-09-05 02:43 bilal ghayyad <bilmar_gh@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: bilal ghayyad @ 2009-09-05 02:43 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to simulate (run) the function
@ 2009-09-05 02:51 Scott Marlowe <scott.marlowe@gmail.com>
parent: bilal ghayyad <bilmar_gh@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2009-09-05 02:51 UTC (permalink / raw)
To: bilal ghayyad <bilmar_gh@yahoo.com>; +Cc: 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 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-09-05 02:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-09-05 02:43 How to simulate (run) the function bilal ghayyad <bilmar_gh@yahoo.com>
2009-09-05 02:51 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox