Re: [GENERAL] Using a multi-valued function in a view

2009-06-05 Thread Radcon Entec
By George, I think you've got it! (Imagine a hokey imitation British accent.) I only had to make one small change.  It complained it didn't know about a column named "charge".  When I changed it to:     select charge, (cn).* from (select charge, chargeneeds(charge) as cn from charge) q; it worke

Re: [GENERAL] Using a multi-valued function in a view

2009-06-04 Thread Merlin Moncure
On Thu, Jun 4, 2009 at 4:40 PM, Radcon Entec wrote: > Merlin, > > Thank you for your reply.  Unfortunately, I was not able to get it to work. > The SQL statements you gave me generated syntax errors. > > I tried to follow your thoughts, though.  I created the following type: > > CREATE TYPE charge

Re: [GENERAL] Using a multi-valued function in a view

2009-06-04 Thread Merlin Moncure
On Thu, Jun 4, 2009 at 11:15 AM, Radcon Entec wrote: > Greetings! > > Having received the answer I needed to my question about using functions > with OUT parameters from this list (thanks very much!), I find myself > confused about how to use the function in a view.  The function chargeneeds > tak

[GENERAL] Using a multi-valued function in a view

2009-06-04 Thread Radcon Entec
Greetings! Having received the answer I needed to my question about using functions with OUT parameters from this list (thanks very much!), I find myself confused about how to use the function in a view.  The function chargeneeds takes one input parameter, a charge number, and has 3 output para