Mega Code Archive

 

Categories / PostgreSQL / String Functions

 

To_char(1 0, 9th Place)

postgres=# SELECT to_char(1.0, '9th "Place"') AS first, postgres-#        to_char(2.2, '9th "Place"') AS second, postgres-#        to_char(pi(), '9th "Place"') AS third, postgres-#        to_char(10, '99V99th "\\"Place\\""') AS shifted_up;    first    |   second   |   third    |   shifted_up ------------+------------+------------+-----------------   1st Place |  2nd Place |  3rd Place |   990th "Place" (1 row) postgres=#