From: | Scrappy <scrappy(at)hub(dot)org> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | 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" <pgsql-advocacy(at)postgresql(dot)org> |
Subject: | Re: New mug design |
Date: | 2009-11-28 23:25:02 |
Message-ID: | CEB1393F-229B-4CF2-9003-84223DF141FC@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
that last one is perfect
Sent from my iPhone
On 2009-11-28, at 18:57, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Marc G. Fournier wrote:
>>> You mean:
>>>
>>> BEGIN;
>>> CREATE TABLE pg_mug (contents TEXT);
>>> INSERT INTO pg_mug VALUES('coffee', 'sugar', 'cream');
>>> COMMIT;
>>>
>>> ?
>>>
>>> I don't think "water" makes sense unless you are making instant
>>> coffee,
>>> which I think is atypical.
>>
>> Ummm ... last I checked, that query will fail with too many
>> fields? :)
>
> Yep, only I could inject a bug into a mug. :-(
>
> The correct query is:
>
> BEGIN;
> CREATE TABLE pg_mug (contents TEXT);
> INSERT INTO pg_mug VALUES('coffee'), ('sugar'), ('cream');
> COMMIT;
>
> That highlights our multi-value INSERT too. :-) With proper wrap it
> would be:
>
> BEGIN;
> CREATE TABLE pg_mug (contents TEXT);
> INSERT INTO pg_mug
> VALUES('coffee'), ('sugar'), ('cream');
> COMMIT;
>
> 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;
>
> FYi, I am just shooting out ideas until someone tells me to stop. ;-)
>
> --
> 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 | Christophe Pettus | 2009-11-28 23:30:39 | Re: New mug design |
Previous Message | Bruce Momjian | 2009-11-28 22:57:38 | Re: New mug design |