Hello All,
Back after a long time to Forums.
Do we have anything equivalent to ISNUMERIC function in Vertica ?
I know this can be done using the REGEXP LIKE function, but looking for something which is more clean and exact to to the requirement.
Thanks
ISNUMERIC function in Vertica
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: ISNUMERIC function in Vertica
Hi nnani!
There isn't an ISNUMERIC function built in, but you can create your own.
See:
http://www.vertica-forums.com/viewtopic ... =isnumeric
There isn't an ISNUMERIC function built in, but you can create your own.
See:
http://www.vertica-forums.com/viewtopic ... =isnumeric
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: ISNUMERIC function in Vertica
Thanks Jim