On Wed, 2004-07-14 at 19:21, Mark Dexter wrote:
> 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.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-07-19 04:05:48|
|Subject: Re: SQL - Indexing for performance on uniquness check... |
|Previous:||From: Oliver Elphick||Date: 2004-07-18 22:13:48|
|Subject: Re: Function compile error|