Re: [SQL] sql query with join and parameter in postgresql function

2004-01-16 Thread Philippe Lang
> > 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

Re: [SQL] sql query with join and parameter in postgresql function

2004-01-16 Thread Michael Glaesemann
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