Re: Re: External search engine, advice

At 01:44 PM 5/20/01 -0400, Tom Lane wrote:

>As far as optimizing indexscans goes, the correct intermediate concept
>would be something like "result is fixed within any one scan", not any
>one transaction.  You wouldn't really want to find that
>
>    begin;
>    select * from foo where x = functhatreadsbar();
>    update bar ...;
>    select * from foo where x = functhatreadsbar();
>    end;
>
>does not give you the desired results.

No, you certainly wouldn't want that.  Cached for the extent of a statement
might make sense.



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.