Skip to content

Instantly share code, notes, and snippets.

@hschnegg

hschnegg/PostgreSQL test if text can be cast to numeric

Created January 28, 2014 15:08
Show Gist options
  • Save hschnegg/8669277 to your computer and use it in GitHub Desktop.
Save hschnegg/8669277 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL: Test if text can be cast to numeric
Raw
PostgreSQL test if text can be cast to numeric
select (mytext ~ '^([0-9]+[.]?[0-9]*|[.][0-9]+)$');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment