Re: [BUGS] Function is called multiple times in subselect

2004-03-12 Thread Alex J. Avriette
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

Re: [BUGS] Function is called multiple times in subselect

2004-03-12 Thread Alex J. Avriette
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

Re: [BUGS] not necessarily a bug...

2004-03-10 Thread Alex J. Avriette
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

Re: [BUGS] not necessarily a bug...

2004-03-09 Thread Alex J. Avriette
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