Calling Functions and Stored Procedures

From: "Mark Dexter" <MDEXTER(at)dexterchaney(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Calling Functions and Stored Procedures
Date: 2004-07-15 15:43:41
Message-ID: 5E8F9F5B63726C48836757FE673B584EE5B630@dcimail.dexterchaney.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Fromme 2004-07-15 16:36:31 Re: Extended query: prepared statements list?
Previous Message Felix E. Klee 2004-07-15 14:25:54 Re: Critique needed for contact-DB draft