Re: New mug design

On Sat, 28 Nov 2009, Bruce Momjian wrote:

Rob Napier wrote:

I suggest that you combine the two ideas:

INSERT INTO pg_mug VALUES('coffee', 'water', 'sugar', 'cream');

And

BEGIN;
CREATE TABLE postgresql (mug_id SERIAL);
COMMIT;

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? :)