xenoterracide/empty.sql

Created January 19, 2010 17:02

Star (0) You must be signed in to star a gist
Fork (1) 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/xenoterracide/281093.js"></script>
Save xenoterracide/281093 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';