Project

General

Profile

« Previous | Next » 

Revision 14128

schemas/util.sql: added cluster(), which reclusters each time

View differences:

trunk/schemas/util.sql
845 845

  
846 846

  
847 847
--
848
-- Name: cluster(regclass, regclass); Type: FUNCTION; Schema: util; Owner: -
849
--
850

  
851
CREATE FUNCTION cluster(table_ regclass, index regclass) RETURNS void
852
    LANGUAGE sql
853
    AS $_$
854
SELECT util.eval($$CLUSTER $$||table_||$$ USING $$||quote_ident(util.name(index)))
855
$_$;
856

  
857

  
858
--
859
-- Name: FUNCTION cluster(table_ regclass, index regclass); Type: COMMENT; Schema: util; Owner: -
860
--
861

  
862
COMMENT ON FUNCTION cluster(table_ regclass, index regclass) IS '
863
idempotent, but reclusters each time
864
';
865

  
866

  
867
--
848 868
-- Name: cluster_index(regclass); Type: FUNCTION; Schema: util; Owner: -
849 869
--
850 870

  

Also available in: Unified diff