Re: [HACKERS] Costs estimates for (inline SQL) functions ...

2006-08-24 Thread Jim C. Nasby
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;

Re: [HACKERS] Costs estimates for (inline SQL) functions ...

2006-08-24 Thread Bruce Momjian
Jim C. Nasby wrote: 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; $$

[HACKERS] Costs estimates for (inline SQL) functions ...

2006-08-20 Thread Hans-Juergen Schoenig
As my last mail did not seem to go through here one more try ... When looking at some fairly complex SQL stuff I came across some interesting issue which is a bit surprising to me: CREATE OR REPLACE FUNCTION xy() RETURNS SETOF record AS $$ SELECT relname::text, relpages::int4

Re: [HACKERS] Costs estimates for (inline SQL) functions ...

2006-08-20 Thread Neil Conway
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