Merlin Moncure wrote:
there are differences. PostgreSQL only really supports functions and
on the lists they are used interchangably. on the -hacker list about
a year back there was a good discussion about implementing true SP and
why they would be needed.
mainly, SP are not externally transactional, making them useful for
maintenance type work, such as vacuum (cant be run from inside a
transaction) or multiple statement data load via 'copy' commands.
i thnk (not sure) that SP can not be inlined into queries like
functions. this would be an important distinction.
Merlin,
thank you for clarifying this. So, given your hint, I didn't miss SP
until now, but this will probably change in future. ;-)
Anastasios
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
