Skip to content

Instantly share code, notes, and snippets.

@gtallen1187

gtallen1187/createISNUMERICfunction.sql

Last active August 29, 2015 13:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gtallen1187/785a105f1f279f954624 to your computer and use it in GitHub Desktop.
Save gtallen1187/785a105f1f279f954624 to your computer and use it in GitHub Desktop.
Download ZIP
syntax for creating function in PG for isnumeric
Raw
createISNUMERICfunction.sql
CREATE FUNCTION isnumeric(text) RETURNS boolean AS '
SELECT $1 ~ ''^[0-9]+$''
' LANGUAGE 'sql';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment