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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +