Hello List,
I wonder if it is possible to make data selected in one query NOT
accessible for a SELECT in another query?
The thing is that I have a cleaning script that selects some rows
from a table and processes them.
During that processing I don't want these rows to end up in another
result set. But I also don't want the other result set to wait until
my cleaning transaction is done, I just want it to ignore it.
Is this possible in the database level or do I need to take care of
it on the application level?
Regards,
Henke
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
