opposite of chr(int)
| От | Henry Drexler |
|---|---|
| Тема | opposite of chr(int) |
| Дата | |
| Msg-id | CAAtgU9RKaT9WQhhZAcMoqJG0rxL-gudB=CwUUOnxORmwuWub=w@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: opposite of chr(int)
Re: opposite of chr(int) |
| Список | pgsql-novice |
Looking at the string functions on:
I only see chr(int) and not something like int(chr).
reading through the others on that page i do not see a int(chr)
the goal is to tell whether or not a character in a string is an integer or not
my current workaround is this:
select
case
when substring('wallawa9kl',8,1) = '0' then 'true'
when substring('wallawa9kl',8,1) = '1' then 'true'
when substring('wallawa9kl',8,1) = '2' then 'true'
when substring('wallawa9kl',8,1) = '3' then 'true'
when substring('wallawa9kl',8,1) = '4' then 'true'
when substring('wallawa9kl',8,1) = '5' then 'true'
when substring('wallawa9kl',8,1) = '6' then 'true'
when substring('wallawa9kl',8,1) = '7' then 'true'
when substring('wallawa9kl',8,1) = '8' then 'true'
when substring('wallawa9kl',8,1) = '9' then 'true'
else 'false'
end
just wondering if there is something more compact or if this is an okay workaround solution.
В списке pgsql-novice по дате отправления: