Re: Maintaining state across function calls - Mailing list pgsql-general

From Tom Lane
Subject Re: Maintaining state across function calls
Date
Msg-id 10942.1353353842@sss.pgh.pa.us
Whole thread Raw
In response to Re: Maintaining state across function calls  (matt@byrney.com)
List pgsql-general
matt@byrney.com writes:
> Thanks for this.  Out of curiosity, why is a static a bad way to do this?

Well, it wouldn't allow more than one instance of the function per
query, and it wouldn't reset correctly after an error, and surely you
agree that your proposal of making the user do a separate "reset" step
is an unreliable and unpleasant-to-use kluge.

            regards, tom lane


pgsql-general by date:

Previous
From: "Welty, Richard"
Date:
Subject: Re: Experiences with pl/Java
Next
From: Jeff Ross
Date:
Subject: Split_part on a CR