Procedures in views

From: Morgan Curley <mcurley(at)e4media(dot)com>
To: "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Procedures in views
Date: 2001-07-23 13:40:46
Message-ID: 4.3.2.7.2.20010723093222.02c90870@e4media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Raymond Chui 2001-07-23 14:00:46 What's wrong with this syntax?
Previous Message Gary Stainburn 2001-07-23 11:30:21 Possible problems with cyclic references