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(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.