Alex Lai <mlai@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
