Re: Costs estimates for (inline SQL) functions ...

From: Neil Conway <neilc(at)samurai(dot)com>
To: Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Costs estimates for (inline SQL) functions ...
Date: 2006-08-21 05:56:12
Message-ID: 1156139773.9480.21.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2006-08-21 06:07:41 Updatable views
Previous Message Hans-Juergen Schoenig 2006-08-21 05:31:28 Costs estimates for (inline SQL) functions ...