Return-Path: postman 
Delivery-Date: Mon, 23 Aug 93 21:22:17 PDT
Return-Path: postman
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA05821; Mon, 23 Aug 93 21:19:20 -0700
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9308240419.AA05821@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: jaws@pangaea.dme.nt.gov.au
Received: from DARWIN.NTU.EDU.AU by postgres.Berkeley.EDU (5.61/1.29)
	id AA05813; Mon, 23 Aug 93 21:19:13 -0700
Received: from dme.nt.gov.au ([155.205.2.1]) by DARWIN.NTU.EDU.AU with SMTP; 
          Tue, 24 Aug 1993 13:59:48 GMT
Received: from pangaea.dme by dme.nt.gov.au (4.1/SMI-4.1)
	id AA20683; Tue, 24 Aug 93 13:58:04 CST
Received: from jaws.dme by pangaea.dme (4.1/SMI-4.1)
	id AA21129; Tue, 24 Aug 93 13:59:16 CST
Date: Tue, 24 Aug 93 13:59:16 CST
From: jaws@pangaea.dme.nt.gov.au (James Woods 61-89-895257)
Message-Id: <9308240429.AA21129@pangaea.dme>
To: postgres@postgres.berkeley.edu
Subject: retrieve into
Resent-To: postgres-dist
Resent-Date: Mon, 23 Aug 93 21:19:19 PDT

I have a query that goes along the lines of:

begin

retrieve into temp ( /* query */ )

/* various other actions related to this table not relevant to this example */

retrieve (temp.all)

destroy temp

end

1) Is there a way of retrieving into a temporary relation that will
automatically be destroid at the end of the transaction block.

2) There appears to be a bug in the method I am using.  If the
transaction aborts the relation "temp" is not created (the desired
result and the reason I am using this inside a begin - end transaction
block).  Unfortunately if the name "temp" is used again as the name of
a relation the backend just sits there in some sort of an infinite
loop.

James Woods
jaws@pangaea.dme.nt.gov.au