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=#
Related examples in the same category