Re: [SQL] INSERT w/o variable names for a SERIAL type? - Mailing list pgsql-sql

Tom Lane writes:

> > INSERT INTO my_table VALUES (a, b, c, DEFAULT, x, y, z, ...);
> 
> I think that is legal SQL92 syntax, but Postgres doesn't accept it
> at present.

Oops!

We do support INSERT .. DEFAULT VALUES, so I guessed too far.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden