Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> 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.
Ignoring trivial syntax differences, I think the important point is that
in Oracle procedures execute outside the database engine, so to speak.
That means they can start and commit transactions. In Postgres,
functions are called inside a transaction and they can't commit it or
start a new one. They can run sub-transactions (savepoints) but they
can't commit a whole transaction. So for example you can never make
partial results of a function's execution visible to another session.
regards, tom lane