eful. This allows indices to be built upon the results of functions. In
one case this proved to be tremendously fast compared to using lower(foo)
dynamically. lower(foo) will always return the same value, as would the
original poster's.
But I digress.
Alex
--
[EMAIL PROTECTED]
Alex J. Avriett
And if you are concerned about the query's cost vs its actual output
(you weren't clear in your original message), there is the 'iscachable'
pragma for functions.
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Unix Systems Gladiator
Liberty in your lifetime: http://www.freestateproj
lly, this really isn't a question
for [EMAIL PROTECTED]
Alex
--
[EMAIL PROTECTED]
Alex J. Avriette, Unix Systems Gladiator
The Emperor Wears No Clothes.
http://www.drugsense.org/wodclock.htm
---(end of broadcast)---
TIP 5: Have yo
On Tue, Mar 09, 2004 at 07:33:31PM -0500, Alex J. Avriette wrote:
> the postgres distribution. Additionally, this really isn't a question
> for [EMAIL PROTECTED]
Meep, my apologies, this wasn't sent to [EMAIL PROTECTED]
--
[EMAIL PROTECTED]
Alex J. Avriette, Solaris Sy