On Mon, 2006-08-21 at 07:31 +0200, Hans-Juergen Schoenig wrote: > CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$ > SELECT relname::text, relpages::int4 > FROM pg_class; > $$ LANGUAGE SQL IMMUTABLE;
> As far as i remember inlined SQL code has been implemented into the > planner around 7.4. We don't currently inline set-returning functions. This has been on my TODO list for a while, but I haven't found the cycles for it yet (of course, if anyone's interested in fixing this, don't let my idleness stop you -- I would think it shouldn't be too difficult). -Neil ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq