Postgres Pro
Downloads
Home   >   mailing lists

Why forbid "INSERT INTO t () VALUES ();" - Mailing list pgsql-hackers

From Fabien COELHO
Subject Why forbid "INSERT INTO t () VALUES ();"
Date
Msg-id alpine.DEB.2.22.394.2006241409070.2453952@pseudo
Whole thread Raw
Responses Re: Why forbid "INSERT INTO t () VALUES ();"  (Thomas Kellerer <shammat@gmx.net>)
Re: Why forbid "INSERT INTO t () VALUES ();"  (Isaac Morland <isaac.morland@gmail.com>)
List pgsql-hackers
Tree view 
Hello devs,

I would like to create an "all defaults" row, i.e. a row composed of the 
default values for all attributes, so I wrote:

   INSERT INTO t() VALUES ();

This is forbidden by postgres, and also sqlite.

Is there any good reason why this should be the case?

-- 
Fabien.

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Custom compression methods
Next
From: Thomas Kellerer
Date:
Subject: Re: Why forbid "INSERT INTO t () VALUES ();"