bruce wrote:
> You can even add stirring:
>
> BEGIN;
> CREATE TABLE pg_mug (contents TEXT);
> INSERT INTO pg_mug
> VALUES('coffee'), ('sugar'), ('cream');
> -- stir
> SELECT * FROM pg_mug ORDER BY random();
> COMMIT;
We can also have different ways of specifying the transaction:
BEGIN/COMMIT
BEGIN WORK/COMMIT WORK
START TRANSACTION/COMMIT
START TRANSACTION/COMMIT WORK
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +