Posts by Tiago Souza • 21 points

• 2

  votes

  3

  answers

  1598

  views

  Q: How to create a FUNCTION to format currency in POSTGRE?

  I created one, but it didn’t work out: CREATE FUNCTION formatar_moeda(valor FLOAT) RETURNS VARCHAR(15) AS $$ DECLARE formatado VARCHAR(15); BEGIN SET formatado = NUMBER(valor,2); SET formatado =…

  postgresql

  asked 8 years, 1 month ago Tiago Souza 21