From c2ff80a8eb48d97ec4c9e7f09a865796a124af23 Mon Sep 17 00:00:00 2001
From: Marko Kreen <markokr@gmail.com>
Date: Thu, 28 Feb 2008 10:12:15 +0000
Subject: [PATCH] versioning for pgq_ext

---
 sql/pgq_ext/Makefile              | 3 ++-
 sql/pgq_ext/functions/version.sql | 8 ++++++++
 2 files changed, 10 insertions(+), 1 deletion(-)
 create mode 100644 sql/pgq_ext/functions/version.sql

diff --git a/sql/pgq_ext/Makefile b/sql/pgq_ext/Makefile
index 695926fb..47f4c354 100644
--- a/sql/pgq_ext/Makefile
+++ b/sql/pgq_ext/Makefile
@@ -2,7 +2,8 @@
 DOCS = README.pgq_ext
 DATA_built = pgq_ext.sql
 
-SRCS = structure/tables.sql functions/track_batch.sql functions/track_event.sql functions/track_tick.sql
+SRCS = structure/tables.sql functions/track_batch.sql functions/track_event.sql \
+       functions/track_tick.sql functions/version.sql
 
 REGRESS = test_pgq_ext
 REGRESS_OPTS = --load-language=plpgsql
diff --git a/sql/pgq_ext/functions/version.sql b/sql/pgq_ext/functions/version.sql
new file mode 100644
index 00000000..5e6be8ac
--- /dev/null
+++ b/sql/pgq_ext/functions/version.sql
@@ -0,0 +1,8 @@
+
+create or replace function pgq_ext.version()
+returns text as $$
+begin
+    return '2.1.6';
+end;
+$$ language plpgsql;
+
-- 
2.39.5