method to call a function

#1

All the online resources I've found so far indicate that the way to call a
function is through a query,
eg, SELECT myFunction(parameter)

Is there a PostgreSQL equivalent for the MS EXECUTE or Oracle's CALL?

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

#2

Soral42, 15.06.2010 05:23:

Quote:

All the online resources I've found so far indicate that the way to call
a function is through a query, eg, SELECT myFunction(parameter)

Is there a PostgreSQL equivalent for the MS EXECUTE or Oracle's CALL?

No

#3

Il 15/06/2010 5.23, Soral42 ha scritto:

Quote:

All the online resources I've found so far indicate that the way to call
a function is through a query,
eg, SELECT myFunction(parameter)

Is there a PostgreSQL equivalent for the MS EXECUTE or Oracle's CALL?

Perhaps PERFORM could be of your interest:

http://www.postgresql.org/docs/8.3/s...S-SQL-NORESULT

#4

On Tue, 15 Jun 2010 09:08:32 +0200, Anselmo Canfora wrote:

Quote:

Il 15/06/2010 5.23, Soral42 ha scritto:
All the online resources I've found so far indicate that the way to
call a function is through a query,
eg, SELECT myFunction(parameter)

Is there a PostgreSQL equivalent for the MS EXECUTE or Oracle's CALL?

Perhaps PERFORM could be of your interest:

http://www.postgresql.org/docs/8.3/static/plpgsql-
statements.html#PLPGSQL-STATEMENTS-SQL-NORESULT

And here is the near future:
http://www.postgresql.org/docs/9.0/s....html#PLPGSQL-
STATEMENTS-EXECUTING-DYN

--
http://mgogala.byethost5.com

#5

On Tue, 15 Jun 2010 17:08:32 +1000, Anselmo Canfora <nobody (AT) nowhere (DOT) net>
wrote:

Quote:

Il 15/06/2010 5.23, Soral42 ha scritto:
All the online resources I've found so far indicate that the way to call
a function is through a query,
eg, SELECT myFunction(parameter)

Is there a PostgreSQL equivalent for the MS EXECUTE or Oracle's CALL?

Perhaps PERFORM could be of your interest:

http://www.postgresql.org/docs/8.3/s...S-SQL-NORESULT

Thankyou. I have been using functions with a return type of VOID, and I
think that using PERFORM to execute them is more correct than using SELECT.

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

method to call a function

comp.databases.postgresql comp.databases.postgresql

method to call a function - 06-14-2010 , 10:23 PM

Re: method to call a function - 06-15-2010 , 12:36 AM

Re: method to call a function - 06-15-2010 , 02:08 AM

Re: method to call a function - 06-15-2010 , 07:27 AM

Re: method to call a function - 06-15-2010 , 06:31 PM