Re: New mug design

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. +