Tom Lane wrote:
>
> begin;
> select * from foo where x = functhatreadsbar();
> update bar ...;
> select * from foo where x = functhatreadsbar();
> end;
>
> does not give you the desired results.
But why would you be marking the function 'iscachable' if you wanted to see the
change there?
Cheers, Andrew.
--
_____________________________________________________________________ Andrew McMillan, e-mail:
Andrew@catalyst.net.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64(21)635-694, Fax: +64(4)499-5596, Office: +64(4)499-2267xtn709
