Postgres Pro
Downloads
Home   >   mailing lists

Re: Not to start a flame war but what does Oracle have that Postgresql does not? - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: Not to start a flame war but what does Oracle have that Postgresql does not?
Date
Msg-id imd5v8$n0m$1@dough.gmane.org
Whole thread Raw
In response to Re: Re: Not to start a flame war but what does Oracle have that Postgresql does not?  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
Responses Re: Re: Not to start a flame war but what does Oracle have that Postgresql does not?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
Rob Richardson, 23.03.2011 16:40:
> What do you mean by "real stored procedures"?  I only know PostGreSQL
> stored procedures.  What are they missing?
>
Postgres only has functions, no procedures.

It's not a big difference but there is one and basically anything you could do with a procedure you can also do a with
afunction. The call syntax is different. That reminds me of another thing that Oracle has: Packages - which are quite
niceto organize a large set of procedures and functions 

Regards
Thomas

pgsql-novice by date:

Previous
From: "Rob Richardson"
Date:
Subject: Re: Re: Not to start a flame war but what does Oracle have that Postgresql does not?
Next
From: Tom Lane
Date:
Subject: Re: Re: Not to start a flame war but what does Oracle have that Postgresql does not?