Postgres Pro
Downloads
Home   >   mailing lists

SELECT INTO TEMP in Trigger? - Mailing list pgsql-sql

From Itai Zukerman
Subject SELECT INTO TEMP in Trigger?
Date
Msg-id 87brzcr8pf.fsf_-_@matt.w80.math-hat.com
Whole thread Raw
In response to Re: count(*), EXISTS, indexes  (Itai Zukerman <zukerman@math-hat.com>)
Responses Re: SELECT INTO TEMP in Trigger?  ("Dan Langille" <dan@langille.org>)
Re: SELECT INTO TEMP in Trigger?  (Itai Zukerman <zukerman@math-hat.com>)
List pgsql-sql
Tree view 
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?

-- 
Itai Zukerman  <http://www.math-hat.com/~zukerman/>

pgsql-sql by date:

Previous
From: Itai Zukerman
Date:
Subject: Re: count(*), EXISTS, indexes
Next
From: Stephan Szabo
Date:
Subject: Re: count(*), EXISTS, indexes