Re: How to insert with a serial

"Mitch Vincent" <mvincent@cablespeed.com> writes:
> insert 'ing a NULL in place of the serial will work too, yes?
> INSERT INTO DEVICES (my_serial_id, name, type, ownerteamid) VALUES
> (NULL,'scoobydoo', 1, 43);

No, that'll insert a NULL.

            regards, tom lane