Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA17045; Tue, 20 Jul 93 16:18:49 -0700
Date: Tue, 20 Jul 93 16:18:49 -0700
From: ananth@ccu1.aukuni.ac.nz (ananth srinivasan)
Subject: Postgres syntax question
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.berkeley.edu
Message-Id: <9307202323.AA08985@ccu1.aukuni.ac.nz>
Content-Type: text
Content-Transfer-Encoding: 7BIT
X-Mailer: ELM [version 2.4 PL21]
Content-Length: 1088

I have a question about Postquel syntax that I need help with.

I have 4 classes say A, B, C, D.

I want to define a C function F that takes several tuples from A, B,
and C, as arguments and returns a set of values.

[Aside: Can I define such a function in the first place?]

Now I want to use the set of values that are returned by the function
to update tuples in D. Specifically, attribute D.a needs updating
using the set of values that the function returns (one tuple update
for each value from the set).

Question:

Does a function call F(A,B,C) in this context make sense?

What should the replace command say?

replace D (a=F(A,B,C)
where ??????)

Any help is appreciated. Thanks.

--Ananth

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ananth Srinivasan                     Phone: +64-9-373-7999 ext. 5328
Dept of MSIS                          Dept:  +64-9-373-7999 ext. 7154
University of Auckland                Fax:   +64-9-373-7430
Private Bag 92019
Auckland, New Zealand
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~