Re: SELECT INTO TEMP in Trigger?

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/