Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA07801; Thu, 3 Jun 93 09:54:22 -0700
Date: Thu, 3 Jun 93 09:54:22 -0700
Message-Id: <9306031654.AA07801@postgres.Berkeley.EDU>
From: MCSMIDCS@CLUSTER.CC.DUNDEE-TECH.AC.UK
Subject: attributes type postquel
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu


I'm building an application which has a class MATCH.

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.

I had originally intended to use attributes of type postquel in LEAGUETABLE
e.g.
	create LEAGUETABLE ( points_total = postquel, etc )
but postquel types don't seem to be included in version 4.1.

I don't want to use functions for this as I want to be able to e.g.
	retrieve (LEAGUETABLE.all)

Creating the attributes of LEAGUETABLE as user-defined types ( C code using 
LIBPQ ) seems unnecessarily overcomplicated. Have I no option ?, no idea ?

Any recent literature besides the user manual ?

Thanks in advance,
			Dave Scott.