| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | bruce(at)momjian(dot)us |
| Cc: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, Rob Napier <rob(at)doitonce(dot)net(dot)au>, Thom Brown <thombrown(at)gmail(dot)com>, damien clochard <damien(at)dalibo(dot)info>, Josh Berkus <josh(at)agliodbs(dot)com>, "Andreas 'ads' Scherbaum" <adsmail(at)wars-nicht(dot)de>, pgsql-advocacy(at)postgresql(dot)org |
| Subject: | Re: New mug design |
| Date: | 2009-11-29 10:49:16 |
| Message-ID: | 200911291049.nATAnHd28996@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas 'ads' Scherbaum | 2009-11-29 12:27:35 | Re: New mug design |
| Previous Message | Bruce Momjian | 2009-11-29 01:27:40 | Re: New mug design |