I saw the same behavior with Functions and Procedures. At first, I could not tell what made one go into the Function folder and one go into the Procedure one. The one thing that clearly distinguishes a Procedure (to be placed into the Procedures folder in PgAdminIII) is if you include an OUT parameter. The first time I wrote a Function with an OUT parameter, I could not find it in the functions folder. I thought at first that it didn't compile. Then I noticed it in the Procedures folder. Probably a lot of other characteristics that make it different, but that is at least one. :)
-Paul
On 7/19/06, Anastasios Hatzis <ahatzis@gmx.net> wrote: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