Calling Functions and Stored Procedures - Mailing list pgsql-novice

From Mark Dexter
Subject Calling Functions and Stored Procedures
Date
Msg-id 5E8F9F5B63726C48836757FE673B584EE5B630@dcimail.dexterchaney.local
Whole thread Raw
Responses Re: Calling Functions and Stored Procedures  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-novice

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.

pgsql-novice by date:

Previous
From: "Felix E. Klee"
Date:
Subject: Re: Critique needed for contact-DB draft
Next
From: Oliver Fromme
Date:
Subject: Re: Extended query: prepared statements list?