Here is a very practical method to format Chilean Rut (xx.xxx.xxx-x) The only requirement is to have the following function previously.PadIndex Postgresql CREATE OR REPLACE FUNCTION public.fn_format_rut(var_rut varchar(12)) RETURNS varchar(12) as $ declare v_cont...
As you may already notice postgresql does not contain the function patidex, it is for this reason that we bring them to you next: CREATE OR REPLACE FUNCTION patindex(pattern VARCHAR, expression VARCHAR ) RETURNS...
Unlike other database engines Postgresql provides us with the initcap() function to apply capital letter to our chains. Here is an example: SELECT initcap(‘HELLO WORLD’); Result: Hello World I hope it’s usefull
