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.
