Vivek Khera <vivek(at)khera(dot)org> writes:
> CREATE OR REPLACE FUNCTION setlogtime(integer) RETURNS void AS $$
> SET log_min_duration_statement = $1;
> SHOW log_min_duration_statement;
> $$ LANGUAGE SQL SECURITY DEFINER;
> How can I write this function?
Use a plpgsql EXECUTE command. In general, utility statements don't
cope with parameters, because that's a planner/executor facility and
utility statements don't go through that. So you've got to substitute
the value you want into the text of the command that's submitted.
regards, tom lane