Received: from victoria.host4u.net (victoria.host4u.net [216.71.64.77]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6NDenf57924 for ; Mon, 23 Jul 2001 09:40:49 -0400 (EDT) (envelope-from mcurley@e4media.com) Received: from morganc.e4media.com ([162.83.164.253]) by victoria.host4u.net (8.8.5/8.8.5) with ESMTP id IAA20485 for ; Mon, 23 Jul 2001 08:39:36 -0500 Message-Id: <4.3.2.7.2.20010723093222.02c90870@e4media.com> X-Sender: mcurley@e4media.com X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Mon, 23 Jul 2001 09:40:46 -0400 To: "pgsql-sql" From: Morgan Curley Subject: Procedures in views Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200107/302 X-Sequence-Number: 4105 Does anyone know if the following is possible: Table A has a list of names with a column entry containing the name of an assoc pl/pgsql function Table B has a list of values Table C is a junction table btw A and B I would like to create a view that returns info from both tables and does a calc on some of the values in B based on the function name stored in A. Can this be done? If so, can someone point me in the right direction for documnetation. Thanks, Morgan