Martijn van Oosterhout <kleptog@svana.org> writes:
> There are some more comprehensive writeups around, but hopefully this
> gives you an idea.
You can find the official(tm) explanation at
http://www.postgresql.org/docs/8.2/static/executor.html
--- in fact, you might want to read all of chapter 42.
regards, tom lane