Re: function to return query result

Peter Maas wrote:
> >Then you can do selects on the view using a where clause:
> >
> >select *
> >from test
> >where a.a='somevalue';
[...]
>yes, but I wanted to encapsulate the more complicated data internals
>(joins, sub queries, etc) in server functions.

OK, I can do that with views also but an advantage of parameterized
views and fucntions is that the SQL Parsing has to be done only once.

Peter

--
------------------------------------------------------------------
Peter Maas, m+r infosysteme, D-52070 Aachen, Hubert-Wienen-Str. 24
Tel +49-241-875094 Fax +49-241-875095 eMail pm(at)mrinfo(dot)de
------------------------------------------------------------------