Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA27487; Thu, 30 Jul 92 16:11:26 -0700
Date: Thu, 30 Jul 92 16:11:26 -0700
Message-Id: <9207302311.AA27487@postgres.Berkeley.EDU>
From: postgres@jdsds1.ir.miami.edu (Raymond D. Frost)
Subject: append problem
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

The following series of commands hang-up the system.
Any help will be appreciated.

create auto
        (serial = char16,
        style = char16,
        color = char16,
        price = int4,
        category = char16)
\g
define rule CatEconomy is
on append to auto
   where new.price >= 10000
     and new.price <  20000
   do instead append auto
      (serial = new.serial,
       style  = new.style,
       color  = new.color,
       price  = new.price,
     category = "Economy")
\g
append auto
        (serial="2222",
         style="sedan",
         color="red",
         price=15000)
\g

Sylvia Shelley
University of Miami