Re: automatic insert of next sequence value? - Thank you!

On Thu, Oct 12, 2000 at 10:22:10AM -0700, Alfred Perlstein wrote:
>> [JB asks about why INSERT INTO foo VALUES ( 0, ... ) doesn't trip the
>> default value]
>
> This is because you're abusing INSERT, the porper way to do insert is
> to specifify which columns explicitly:
>
> INSERT INTO foo (col1, col3) VALUES ( 5, 6 );
>
> now, if col2 has a default value it will be set properly.

I feel so dirty.  I only hope the INSERT statement can forgive me, and that
I can make reparations for my sins.  :-)

> -Alfred

Thanks Alfred, and to the several other people who responded so quickly
to my, ahem, query.  No need to cc: me, btw, I'm on the list and hope to
learn more from it.

--JB

--
------------------------------------------------------------------
                J B Bell            |              /~\
          Systems Administrator     |       ASCII  \ /  Against
            Internet Gateway        |      Ribbon   X   HTML
                                    |    Campaign  / \  Mail