X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8345F4762E1 for ; Fri, 11 Apr 2003 18:15:06 -0400 (EDT) Received: from bast.unixathome.org (bast.unixathome.org [66.11.174.150]) by postgresql.org (Postfix) with ESMTP id F26024762EF for ; Fri, 11 Apr 2003 18:15:05 -0400 (EDT) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id 0A1893F4E; Fri, 11 Apr 2003 18:15:08 -0400 (EDT) From: "Dan Langille" To: Itai Zukerman Date: Fri, 11 Apr 2003 18:15:07 -0400 MIME-Version: 1.0 Subject: Re: SELECT INTO TEMP in Trigger? Cc: pgsql-sql@postgresql.org Message-ID: <3E97062B.27895.20A9935B@localhost> References: <87smsora9b.fsf@matt.w80.math-hat.com> (Itai Zukerman's message of "Fri, 11 Apr 2003 17:32:00 -0400") In-reply-to: <87brzcr8pf.fsf_-_@matt.w80.math-hat.com> X-mailer: Pegasus Mail for Windows (v4.02a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Spam-Status: No, hits=-16.1 required=5.0 tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/192 X-Sequence-Number: 12893 On 11 Apr 2003 at 18:05, Itai Zukerman wrote: > This seems to not be possible is plpgsql: > > SELECT DISTINCT A.x INTO TEMP X FROM A,B WHERE A.x=B.x; > > Is there some way to create a temporary table in plpgsql? Yes. http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql- selectinto.html -- Dan Langille : http://www.langille.org/