1 files changed, 25 insertions, 0 deletions
diff --git a/sql/functions/auth.get_all_active_users.sql b/sql/functions/auth.get_all_active_users.sql
new file mode 100644
index 0000000..243be63
--- /dev/null
+++ b/sql/functions/auth.get_all_active_users.sql
@@ -0,0 +1,25 @@
+drop function auth.get_all_active_users ();
+
+create or replace function auth.get_all_active_users ()
+returns setof auth.users
+as $$
+begin
+    return query
+    select u.id,
+        u.username,
+        u.pwd,
+        u.first_name,
+        u.last_name,
+        u.email,
+        u.phone,
+        u.active,
+        u.created
+    from auth.users u
+    where u.active = true::bool
+    order by u.last_name asc,
+        u.first_name asc,
+        u.id asc;
+
+    return;
+end;
+$$ language plpgsql;