ISNUMERIC function in Vertica

Moderator: NorbertKrupa

Post Reply
User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

ISNUMERIC function in Vertica

Post by nnani » Mon Feb 03, 2014 12:18 pm

Hello All,
Back after a long time to Forums. :D

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
nnani........
Long way to go

You can check out my blogs at vertica-howto

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1824
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: ISNUMERIC function in Vertica

Post by JimKnicely » Mon Feb 03, 2014 2:19 pm

Hi nnani!

There isn't an ISNUMERIC function built in, but you can create your own.

See:

http://www.vertica-forums.com/viewtopic ... =isnumeric
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: ISNUMERIC function in Vertica

Post by nnani » Mon Feb 03, 2014 3:10 pm

Thanks Jim :)
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “Vertica SQL”