Request a Demo
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: [SQL] INSERT w/o variable names for a SERIAL type?
Date
Msg-id Pine.LNX.4.21.0002280059490.2468-100000@localhost.localdomain
Whole thread Raw
In response to Re: [SQL] INSERT w/o variable names for a SERIAL type?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [SQL] INSERT w/o variable names for a SERIAL type?
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [SQL] Nested BEGIN...COMMIT transactions
Next
From: Mark Kirkwood
Date:
Subject: Re: [SQL] New Optimizer Behaviour In 7.0b1