Re: INSERT... WHERE

On 1/13/13, Chris Angelico <rosuav(at)gmail(dot)com> wrote:
> On Mon, Jan 14, 2013 at 3:37 PM, Robert James <srobertjames(at)gmail(dot)com>
> wrote:
>> Thanks. But how do I do that where I have many literals? Something like:
>>
>> INSERT INTO seltest (id, a, b) SELECT (1,2,3),(4,5,6),(7,8,9) WHERE b
>> IN (SELECT ...)
>
> You can use WITH clauses in crazy ways with PostgreSQL. I haven't
> actually tried it, but you should be able to put your VALUES behind a
> WITH, then SELECT from that WHERE blah blah, and INSERT that SELECT.
>
> As they say, knock yourself out! :)
>
> ChrisA

I don't quite follow - could you please elaborate?