Función Postgres para convertir número a palabras
CREATE OR REPLACE FUNCTION fn_num_a_palabra(num BIGINT) RETURNS TEXT AS $$ DECLARE palab TEXT; BEGIN WITH menor20(palabra, id) AS ( VALUES ('CERO', 0), ('UNO', 1),( 'DOS', 2 ), ( 'TRES', 3), ( 'CUATRO', 4 ), ( 'CINCO', 5 ), ( 'SEIS', 6 ), ( 'SIETE', 7 ), ( 'OCHO', 8), ( 'NUEVE', 9), ( 'DIEZ', 10), ( 'ONCE', 11 ), ( 'DOCE', 12 ), ( 'TRECE', 13 ), ( 'CATORCE', 14), ( 'QUINCE', 15 ), ('DIECISEIS', 16 ), ( 'DIECISIETE', 17), ('DIECIOCHO', 18 ), ( 'DIECINUEVE', 19 ) ), menor100(palabra, id) AS ( VALUES ('VEINTE', 2), ('TREINTA', 3),('CUARENTA', 4), ('CINCUENTA', 5), ('SESENTA', 6), ('SETENTA', 7), ('OCHENTA', 8), ('NOVENTA', 9) ) SELECT CASE ...