SELECT INTO TEMP in Trigger?

From: Itai Zukerman <zukerman(at)math-hat(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECT INTO TEMP in Trigger?
Date: 2003-04-11 22:05:32
Message-ID: 87brzcr8pf.fsf_-_@matt.w80.math-hat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-04-11 22:11:58 Re: count(*), EXISTS, indexes
Previous Message Itai Zukerman 2003-04-11 22:02:37 Re: count(*), EXISTS, indexes