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