On Tue, Aug 10, 2010 at 6:46 PM, Tom Lane wrote:
>
> That's just one SELECT command. Sub-SELECTs inside a query don't
> count as separate commands for this purpose; the use of SELECT in
> that way is just an artifact of the SQL grammar.
Thanks. That's what I figured, but wanted to make sure.
e
Eric Ridge writes:
> http://www.postgresql.org/docs/8.4/static/transaction-iso.html says:
> "Also note that two successive SELECT commands can see different data,
> even though they are within a single transaction, if other
> transactions commit changes during execution of the first SELECT."
> I
