Return-Path: owner-postman 
Delivery-Date: Mon, 09 May 94 12:39:50 -0700
Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id IAA27513 for postgres-redist; Mon, 9 May 1994 08:25:06 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199405091525.IAA27513@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from mozart.ms.uky.edu (mozart.ms.uky.edu [128.163.128.127]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id IAA27503 for <postgres@postgres.berkeley.edu>; Mon, 9 May 1994 08:25:05 -0700
Received: from s.ms.uky.edu by mozart.ms.uky.edu id ad09890; 9 May 94 15:02 GMT
Subject: 'retrieve into' in a rule?
To: postgres@postgres.Berkeley.EDU
Date: Mon, 9 May 1994 10:59:52 -0400 (EDT)
X-Mailer: ELM [version 2.4 PL13]
Content-Type: text
Content-Length: 595       
From: keen@ms.uky.edu
X-Sender: keen@ms.uky.edu
Message-ID: <9405091459.aa05728@s.s.ms.uky.edu>
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 09 May 94 08:25:06 -0700
Resent-XMts: smtp


I am running with Postgres 4.2.

When I give a command to the monitor like
"retrieve into temp (emp.name) where emp.age = 40\g"

it works fine and creates the class temp with the info,
BUT if I put the same kind of command into a _rule_,

"define rule r5 is on 
retrieve to emp.age where current.age ISNULL
 do [retrieve into x (emp.all) where emp.dept= current.dept ] \g"

the rule is defined alright, 
but when I actually try to retrieve from emp, 
"retrieve (emp.all) \g"
I get a message that "type x already defined" 
and no tuples are retrieved.

Suggestions?

Debby Keen
keen@ms.uky.edu


===============================================================================
    To add/remove yourself from the POSTGRES mailing list: send mail with 
    the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

    If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
    a human will deal with it.  DO NOT post to the "postgres" mailing list.
===============================================================================