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

From Maurice Gittens
Subject Re: Why No WHERE clause for INSERT statements
Date
Msg-id AANLkTim3QEesn3_8DLEOqVEy9TBBb93uF=wwwT-7SDvo@mail.gmail.com
Whole thread Raw
In response to Re: Why No WHERE clause for INSERT statements  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>
> All that stuff is buried in the "query" option.  You can do something
> like
>
>        INSERT INTO table SELECT ... WHERE ...
>
> so the full power of SELECT is available already.
>
>                        regards, tom lane
>

Thank you Michael, Tom; I must have missed the nonterminal symbol
'query' in the syntax rule;

Kind regards.
Maurice

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Postgresql's table & index compared to that of MySQL
Next
From: Thom Brown
Date:
Subject: Re: Postgresql's table & index compared to that of MySQL