Re: Simple question on SELECT

On 11/07/11 2:41 PM, Edson Richter wrote:
> Does simple SELECT query like
>
> select * from tableX
>
> (without FOR UPDATE) opens an implicit transaction when issued?

opens and closes.    if you don't bracket with BEGIN;  ....
COMMIT|ROLLBACK;    then each statement is a transaction of and by itself



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast