Neil, > This works, but it seems overly verbose. It occurred to me that we could > easily add a new PL/PgSQL statement that evaluates a set-returning > expression and adds *all* the resulting rows to the function's result > set. For example: > > RETURN QUERY SELECT ...; > > I'm not sure of the right name: "RETURN ROWS" or "RETURN ALL" might also > work. Of course, this is syntax sugar (and superficial sugar at that), > but I believe this is a fairly common requirement. > > Comments?
Hmmm ... "ALL" is already a reserved word, so is unlikely to be a variable name, yes? I'd think we could get some breakage on "ROWS". So I'd go for "RETURN ALL". Overall, I think this is worthwhile, but maybe not enough to bypass feature freeze. -- Josh Berkus PostgreSQL @ Sun San Francisco ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster