Theoretical - restrict references

I understand that the restrict references pragma enforces that the function, procedure, etc., does not do certain things to certain tables.

Can someone elaborate on what we are trying to avoid? A sort of mutating trigger like problem? Like selecting from a table for which we are updating the same table?

Please.. all sorts of examples... interested...

Thanks,
D Received on Thu Feb 22 2001 - 00:32:06 CST