All pastes #218197 Raw Edit

Unnamed

public sql v1 · immutable
#218197 ·published 2006-10-24 01:34 UTC
rendered paste body
CREATE OR REPLACE FUNCTION sortLetters(text) RETURNS text AS $$	DECLARE		i INT := 0;		test VARCHAR(10) := $1;		passed BOOLEAN := false;	BEGIN		WHILE NOT passed LOOP			passed := true;			WHILE i <= length(test) LOOP				IF (i > 0 AND substr(test, i, 1) < substr(test, i-1, 1)) THEN						test   := substr(test, 0, i-1) || substr(test, i, 1) || substr(test, i-1, 1) || substr(test, i+1, length(test) - i);						passed := false;				END IF;				i := i + 1;			END LOOP;		END LOOP;		return test;	END;$$ LANGUAGE plpgsql STRICT IMMUTABLE;