Postgres: Динамический SQL-запрос


CREATE OR REPLACE FUNCTION client.fx_admin_del(admin_id integer)
  RETURNS integer AS
$BODY$
--
-- Удаление admin
--
BEGIN

    PERFORM client.fx_check_admin_id($1);
    EXECUTE 'DELETE FROM client.admins WHERE admin_id= ' || quote_ident($1);
    RETURN 1;

END
-- eof
$BODY$
  LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER
  COST 100;
ALTER FUNCTION client.fx_admin_del(integer) OWNER TO sk4_admin;
GRANT EXECUTE ON FUNCTION client.fx_admin_del(integer) TO sk4_admin;
GRANT EXECUTE ON FUNCTION client.fx_admin_del(integer) TO public;