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 MAA25893 for postgres-dist; Thu, 24 Mar 1994 12:38:55 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199403242038.MAA25893@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 sunic.sunet.se (sunic.sunet.se [192.36.125.2]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id MAA25878 for ; Thu, 24 Mar 1994 12:38:48 -0800 Received: from cocos.fuw.edu.pl by sunic.sunet.se (8.6.8/2.03) id VAA03168; Thu, 24 Mar 1994 21:38:12 +0100 Received: from perseus.tup.edu.pl ([150.254.5.1]) by cocos.fuw.edu.pl (4.1/SMI-4.1) id AA21201; Thu, 24 Mar 94 21:37:57 +0100 Received: from kastor.ics.tup.edu.pl by perseus.tup.edu.pl id aa04906; Thu, 24 Mar 94 21:33:58 MET Received: from KASTOR/MAILQUEUE by kastor.ics.tup.edu.pl (Mercury 1.1); Thu, 24 Mar 94 21:26:05 CET-0 From: "MARCIN JANUCHTA (P.445)" To: postgres@postgres.Berkeley.EDU Date: Thu, 24 Mar 1994 21:25:39 CET-0 X-File: NEMAIL.TXT X-Finfo: DOS,"NEMAIL.TXT",,,,Text Subject: lispRead error Priority: normal X-Mailer: PMail v3.0 (R1a) Message-Id: <96C266D67@kastor.ics.tup.edu.pl> Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Thu, 24 Mar 94 12:38:54 -0800 Resent-XMts: smtp I have defined a rule (in v.4.1) : define rule ne is on append to emp do replace new (salary=int4ave{emp.salary}) append emp(number=1234,name="Joe",salary=20000) Query sent to backend is "append emp(number=1234,name="Joe",salary=20000) " WARN:Mar 24 18:34:11:Bad type (lispRead) Can anybody advise me what's the problem? Is the aggregate call responsible for the failure? Is it due to a general ban on fuctions in rule actions? Thanks in advance, Martin ------------------------- M.Januchta martin@pozn1v.tup.edu.pl Institute of Computing Science @kastor.ics.tup.edu.pl Poznan Technical University Poznan, Poland