On Sun, Aug 20, 2006 at 10:56:12PM -0700, Neil Conway wrote: > 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).
We should put this on the project's TODO... -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
