On Sun, Oct 19, 2008 at 04:03:47PM +0200, Alain Roger wrote:
> i created a stored procedure (function) under postgreSQL and when i checked
> deeper into my DB, this is what i get:
>
> END;
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE
> COST 100;
> ALTER FUNCTION myschema.get_count_languages(
that's for planner to know. You can estimate cost in there, of that
procedure. I usually use select * from something limit 1 times number of
rows that procedure returns on average. But I am sure, some more smart
people here would have different ways to set it.
Hi,
i created a stored procedure (function) under postgreSQL and when i checked
deeper into my DB, this is what i get:
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
ALTER FUNCTION myschema.get_count_languages(character varying) OWNER TO
myuser;
to what corresponds the parameter C
