Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AB4FF476F8D for ; Fri, 1 Nov 2002 16:27:24 -0500 (EST) Received: from mail.memeticsystems.com (flywheel.memeticsystems.com [64.85.80.85]) by postgresql.org (Postfix) with SMTP id 08135476F85 for ; Fri, 1 Nov 2002 16:27:23 -0500 (EST) Received: (qmail 28302 invoked from network); 1 Nov 2002 21:27:24 -0000 Received: from unknown (HELO ?10.0.0.102?) (63.249.24.21) by 0 with SMTP; 1 Nov 2002 21:27:24 -0000 Subject: making queries more effecient From: "Peter T. Brown" To: pgsql-sql@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 01 Nov 2002 14:24:52 -0800 Message-Id: <1036189492.2013.16.camel@localhost.localdomain> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/18 X-Sequence-Number: 10160 Hi. I have this query that I have been trying to reduce to a single statement, but haven't figured out how. Am I missing something? CREATE TEMP TABLE temp20561149207391 AS SELECT DISTINCT ON ("VisitorID") "VisitorID","Type" FROM "ProgramEvent" WHERE "ProgramID" = 10 ORDER BY "VisitorID","Created" DESC;INSERT INTO "VisitorPointer839" ("VisitorID") SELECT temp20561149207391."VisitorID" FROM temp20561149207391 WHERE temp20561149207391."Type" = 0 Thanks