Array of C integers to temporary table? - Mailing list pgsql-novice

Hello.

What's the "correct" (read: simple, efficient) way to
pass an arbitrarily sized array of C integers to postgres
and have it turned into a temporary table?

I'm using PostgreSQL 7.4.

I could, of course, turn the array into a long list of
insert statements:

  BEGIN;
  CREATE TEMPORARY TABLE temp_table (id integer) ON COMMIT DROP;
  INSERT INTO temp_table VALUES (1);
  INSERT INTO temp_table VALUES (23);
  INSERT INTO temp_table VALUES (3889);
  ...

But that seems long winded and rather inefficient.

Any help appreciated!