[GENERAL] Can this function be declared IMMUTABLE?

2007-08-29 Thread beickhof
Hello, I have a question about whether I can safely declare a function IMMUTABLE. Citing the documentation under Function Volatility Categories in the section on Extending SQL: It is generally unwise to select from database tables within an IMMUTABLE

Re: [GENERAL] Can this function be declared IMMUTABLE?

2007-08-29 Thread Jaime Casanova
On 8/27/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Well, I am considering a function that does read from a table, but the table contents change extremely infrequently (the table is practically a list of constants). Would it be safe to declare the function IMMUTABLE provided that the table

Re: [GENERAL] Can this function be declared IMMUTABLE?

2007-08-29 Thread Josh Tolley
On 8/27/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello, I have a question about whether I can safely declare a function IMMUTABLE. Citing the documentation under Function Volatility Categories in the section on Extending SQL: It is generally

[GENERAL] Can this function be declared IMMUTABLE?

2007-08-28 Thread beickhof
Hello, I have a question about whether I can safely declare a function IMMUTABLE. Citing the PostgreSQL documentation under Function Volatility Categories in the section on Extending SQL: It is generally unwise to select from database tables within an

Re: [GENERAL] Can this function be declared IMMUTABLE?

2007-08-28 Thread Bill Moran
In response to [EMAIL PROTECTED]: Hello, I have a question about whether I can safely declare a function IMMUTABLE. Citing the PostgreSQL documentation under Function Volatility Categories in the section on Extending SQL: It is generally unwise

Re: [GENERAL] Can this function be declared IMMUTABLE?

2007-08-28 Thread Tom Lane
[EMAIL PROTECTED] writes: Well, I am considering a function that does select from a table, but the table contents change extremely infrequently (the table is practically a list of constants). Would it be safe to declare the function IMMUTABLE provided that the table itself is endowed with

Re: [GENERAL] Can this function be declared IMMUTABLE?

2007-08-28 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] writes: Well, I am considering a function that does select from a table, but the table contents change extremely infrequently (the table is practically a list of constants). Would it be safe to declare the function IMMUTABLE provided