Re: A couple of newbie questions ... - Mailing list pgsql-general

Shane Ambler wrote:
> Raymond O'Donnell wrote:
>
...
>> INSERT INTO table (fld_y, fld_z) VALUES ('y', 'z');
>
> Another way is INSERT INTO table VALUES (NULL,'y','z')

of course you meant:

INSERT INTO table VALUES (DEFAULT,'y','z')

since Null would be wrongly insert NULL value instead
of using the sequence value.

Regards
Tino