miércoles, 25 de enero de 2012

Right


-- Function: fnt_right(character varying, integer)

-- DROP FUNCTION fnt_right(character varying, integer);

CREATE OR REPLACE FUNCTION fnt_right(character varying, integer)
  RETURNS character varying AS
$BODY$
begin

    return substring($1, length($1) - $2 + 1, length($1));

end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION fnt_right(character varying, integer)
  OWNER TO adempiere;

No hay comentarios:

Publicar un comentario