Re: Subselect query for a multi table insert single query - Mailing list pgsql-novice

"Norman Khine" <norman@khine.net> writes:
>  What should be the correct syntax for embedding this.

This would work fine:

INSERT INTO table VALUES (foo, bar, baz, currval('seq'), ...);

The elements of an INSERT/VALUES list are expressions, not
necessarily literal constants.

            regards, tom lane