Procedures vs Functions

#1

Hi, I know the difference beetwen Proc and Func, the former shoud not return a
value and the latter should. But it seems that within Postgres they have
different meanings. Could someone explain this to me?

Thank you very much

Corrado

#2

Corrado Alesso <coPUNTOalesso (AT) fastwebnet (DOT) it> wrote:

Quote:

Hi, I know the difference beetwen Proc and Func, the former shoud not
return a value and the latter should. But it seems that within Postgres
they have different meanings. Could someone explain this to me?

It is simple: PostgreSQL does not have procedures as specified by the
SQL standard.

You can, however, declare a function of return type void.

Yours,
Laurenz Albe

#3

Laurenz Albe ha scritto:

Quote:

Corrado Alesso <coPUNTOalesso (AT) fastwebnet (DOT) it> wrote:
Hi, I know the difference beetwen Proc and Func, the former shoud not
return a value and the latter should. But it seems that within Postgres
they have different meanings. Could someone explain this to me?

It is simple: PostgreSQL does not have procedures as specified by the
SQL standard.

You can, however, declare a function of return type void.

Yours,
Laurenz Albe

Thank you, it's clear now.

Corrado

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

Procedures vs Functions

comp.databases.postgresql comp.databases.postgresql

Procedures vs Functions - 03-20-2007 , 02:28 AM

Re: Procedures vs Functions - 03-20-2007 , 10:11 AM

Re: Procedures vs Functions - 03-27-2007 , 03:53 PM