> > I thought a view would be more appropriate, but
> > if I'm not wrong, a view does not accept any parameter
> > as input...
>
> But you can just define the view and select it with a WHERE clause
with
> your parameter, just like a normal table. Would that help?
Thanks! That's perfect. I join in
On Jan 16, 2004, at 8:30 PM, Philippe Lang wrote:
Hello,
I'd like to write a function similar to that:
CREATE FUNCTION public.report_join_parameter(char(6))
RETURNS ??? AS
Do I ***HAVE TO*** define a composite type for the columns my function