Return-Path: postman 
Delivery-Date: Tue, 24 Aug 93 09:46:33 PDT
Return-Path: postman
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA08650; Tue, 24 Aug 93 09:41:59 -0700
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9308241641.AA08650@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: hamiltop@computer-science.manchester.ac.uk
Received: from sun2.nsfnet-relay.ac.uk by postgres.Berkeley.EDU (5.61/1.29)
	id AA08642; Tue, 24 Aug 93 09:41:52 -0700
Via: uk.ac.manchester.computer-science; Tue, 24 Aug 1993 17:50:40 +0100
Date: Tue, 24 Aug 93 17:50:33 BST
From: M92 <hamiltop@computer-science.manchester.ac.uk>
Message-Id: <9308241650.AA01066@n8o.cs.man.ac.uk>
To: postgres@postgres.Berkeley.EDU
Subject: iteration of query
Resent-To: postgres-dist
Resent-Date: Tue, 24 Aug 93 09:41:58 PDT

Can you specify that a query is to iterate until nomore results are found ?
As suggested in the ACM 34:10 paper on postgres, ie

retrieve * into answer
(PARENT.parent) from a in answer
where PARENT.method = "SINE"
or PARENT.method = a.parent \g

when I run such a query postgres hangs-up.

If I the space between the retrieve command and * is missing the parser returns 
an error.

Thanks Paul