Re: Planner forces seq scan when select without quoting its values - Mailing list pgsql-general

Alex Lai <mlai@sesda2.com> writes:
>    "EXPLAIN insert into alex1 (fileid, archiveset) select 35352974, 10003;"
> [vs]
>    "EXPLAIN insert into alex1 (fileid, archiveset) select '35352974', '10003';"

You might be happier using INSERT ... VALUES instead of INSERT
... SELECT for this.  In the former, the parser is going to be more
aggressive about forcing values to the correct datatype, which is the
root of your difficulties here.

            regards, tom lane