Re: [HACKERS] Extended customizing, SQL functions, internal variables, API

2004-05-28 Thread Bruno Wolff III
On Fri, May 28, 2004 at 12:46:29 -0400, [EMAIL PROTECTED] wrote: > It occurs to me that there is a need for internal state variables that can > be accessed either by functions or something similar. But there still needs to be multiple copies to take into account that different transactions may n

[HACKERS] Extended customizing, SQL functions, internal variables, API

2004-05-28 Thread pgsql
I'm not really sure what to call this feature, but I have been talking to a potential customer and they need a particular feature and they need to to be very FAST. Take this query: select sum(num) from table; Now, if that table is very large, this can take a lot of time. Using a trigger, one ca