Calling Functions and Stored Procedures

#1

Quote:

I understand that functions in Postgres server the purpose of both
functions and stored procedures in other db's (e.g., MSSQL and
Oracle). In these other databases, you call a stored procedure with
different syntax (e.g., CALL <procedure name>) instead of using it in
line in a SELECT statement.

My question is this: If I write a Postgres function that is not
designed to be part of a query (e.g., it should just do something), do
I still use a SELECT statement to execute the function? Is there some
other syntax that is the equivalent to CALL or EXEC?

Thanks for your help.

#2

On Thu, 2004-07-15 at 16:43, Mark Dexter wrote:
....

Quote:

My question is this: If I write a Postgres function that is not
designed to be part of a query (e.g., it should just do something), do
I still use a SELECT statement to execute the function? Is there some
other syntax that is the equivalent to CALL or EXEC?

No, you always use SELECT to call a function.

For example, to change the value of a sequence (using a built-in
function):

SELECT nextval('table_field_seq',553);

Oliver Elphick

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#3

On Wed, 2004-07-14 at 19:21, Mark Dexter wrote:

Quote:

I understand that functions in Postgres server the purpose of both
functions and stored procedures in other db's (e.g., MSSQL and
Oracle). In these other databases, you call a stored procedure with
different syntax (e.g., CALL <procedure name>) instead of using it in
line in a SELECT statement.

My question is this: If I write a Postgres function that is not
designed to be part of a query (e.g., it should just do something), do
I still use a SELECT statement to execute the function? Is there some
other syntax that is the equivalent to CALL or EXEC?

Nope, you still use the select function() syntax for that too.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

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

Calling Functions and Stored Procedures

comp.databases.postgresql.novice comp.databases.postgresql.novice

Calling Functions and Stored Procedures - 07-15-2004 , 10:43 AM

Re: Calling Functions and Stored Procedures - 07-15-2004 , 11:46 AM

Re: Calling Functions and Stored Procedures - 07-18-2004 , 05:39 PM