agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: keen@ms.uky.edu
To: postgres@postgres.Berkeley.EDU
Subject: 'retrieve into' in a rule?
Date: Mon, 9 May 1994 10:59:52 -0400 (EDT)
Message-ID: <9405091459.aa05728@s.s.ms.uky.edu> (raw)


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.
===============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: keen@ms.uky.edu
  Subject: Re: 'retrieve into' in a rule?
  In-Reply-To: <9405091459.aa05728@s.s.ms.uky.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox