On Mon, Jan 14, 2013 at 3:37 PM, Robert James <srobertja...@gmail.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
