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

From Bruce Momjian
Subject Re: [SQL] INSERT w/o variable names for a SERIAL type?
Date
Msg-id 200002280019.TAA11427@candle.pha.pa.us
Whole thread Raw
In response to Re: [SQL] INSERT w/o variable names for a SERIAL type?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> 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.

We do?  What does the DEFAULT do?


--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: [SQL] New Optimizer Behaviour In 7.0b1
Next
From: Christopher Sawtell
Date:
Subject: [SQL] 7.0beta1?