Re: SELECT INTO TEMP in Trigger?

From: "Dan Langille" <dan(at)langille(dot)org>
To: Itai Zukerman <zukerman(at)math-hat(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SELECT INTO TEMP in Trigger?
Date: 2003-04-11 22:15:07
Message-ID: 3E97062B.27895.20A9935B@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Itai Zukerman 2003-04-11 22:15:09 Re: SELECT INTO TEMP in Trigger?
Previous Message Stephan Szabo 2003-04-11 22:12:09 Re: count(*), EXISTS, indexes