Return-Path: pg_adm@postgres.berkeley.edu Received: by postgres.Berkeley.EDU (5.61/1.29) id AA14888; Fri, 4 Jun 93 05:12:18 -0700 Message-Id: <9306041212.AA14888@postgres.Berkeley.EDU> From: Peter van Oosterom Subject: Re: attributes type postquel To: postgres@postgres.berkeley.edu Sender: pg_adm@postgres.berkeley.edu To: MCSMIDCS@cluster.cc.dundee-tech.ac.uk Date: Fri, 4 Jun 93 14:11:50 MET DST Cc: postgres@postgres.berkeley.edu In-Reply-To: <9306031654.AA07801@postgres.Berkeley.EDU>; from "MCSMIDCS@cluster.cc.dundee-tech.ac.uk" at Jun 3, 93 9:54 am X-Mailer: ELM [version 2.3 PL11] > > create MATCH ( hometeam = text, awayteam = text, fixture = text, > homeselect = selection, awayselect = selection, result = int2, > goalscorers = selection, etc ) > > I want to create a class LEAGUETABLE which will use the data in MATCH to > build a leaguetable. > Some time age we developed a sample application which did just this. Rules are used to update the LEAGUETABLE, when new results are added to the MATCH class. Using the 'sort by' clause in a retrieve will give the proper ranking. Everything is done in Postquel. If you are interested, I could try to locate the scripts which defined the data model and rules, and some scripts for populating the classes. Regards, Peter van Oosterom. (email: oosterom@fel.tno.nl)