Re: Why No WHERE clause for INSERT statements

From: Maurice Gittens <mainmanmauricio(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why No WHERE clause for INSERT statements
Date: 2010-08-17 15:03:59
Message-ID: AANLkTim3QEesn3_8DLEOqVEy9TBBb93uF=wwwT-7SDvo@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-08-17 15:21:18 Re: Postgresql's table & index compared to that of MySQL
Previous Message Thom Brown 2010-08-17 15:00:22 Re: Postgresql's table & index compared to that of MySQL