Re: Why No WHERE clause for INSERT statements - Mailing list pgsql-general

On Aug 17, 2010, at 4:32 , Maurice Gittens wrote:

> More specifically; the INSERT statement is currently defined as:
>
> INSERT INTO table [ ( column [, ...] ) ]
>    { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [,
> ...] | query }
        ^^^^^

INSERT INTO table [ ( column [, ...] ) ]
  SELECT ...
    WHERE condition

> This syntax would allow tuples to be inserted only when some condition is true.
> What I am missing?

See above.

Michael Glaesemann
grzm seespotcode net