Store exponent in postgres table

Question

I have a value to store in my table

10⁴

the only exponent that i can store is ².

any solution ?!?

Have you tried just inserting `1000`? What does your code look like? — Gordon Linoff, Dec 11 '18 at 15:53
@GordonLinoff I need it to look like ten exponent ³ not `1000` — Yagami Light, Dec 11 '18 at 15:54
Works for me. What is the problem? https://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=49d23d6562f5461a1ae88305f7199476 — S-Man, Dec 11 '18 at 15:56

score 2 · Accepted Answer · answered Dec 11 '18 at 16:16

2

You can try to use translate function to make a mapper table.

LOG to get exponent from ten, then use concat to get your expect result.

SELECT concat(10,translate(LOG(1000)::varchar, '123456789', '¹²³⁴⁵⁶⁷⁸⁹'))

answered Dec 11 '18 at 16:16

D-Shih

You are a boss bro (i will make it as an answer as soon as possible) – Yagami Light Dec 11 '18 at 16:20
Related: https://stackoverflow.com/questions/17908593/how-to-find-the-unicode-of-the-subscript-alphabet – jchevali Dec 11 '18 at 17:43
1

This is a really great one! – S-Man Dec 12 '18 at 18:26

1 Answers1