jheidt/empty.sql

Forked from xenoterracide/empty.sql

Created October 26, 2015 22:56

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jheidt/32df7bf593bbb9b0b2bd.js"></script>
Save jheidt/32df7bf593bbb9b0b2bd to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

xenoterracide created this gist Jan 19, 2010.

empty.sql

-Original file line number
+Diff line change
@@ -0,0 +1,7 @@
+     CREATE OR REPLACE FUNCTION empty(TEXT)
+    RETURNS bool AS
+            $$ SELECT $1 ~ '^[[:space:]]*$'; $$
+            LANGUAGE sql
+            IMMUTABLE;
+    COMMENT ON FUNCTION empty(TEXT)
+            IS 'Find empty strings or strings containing only whitespace';