From b4d3656d5050a4875f8b264b7eb3e174cd8faf2b Mon Sep 17 00:00:00 2001
From: Evgeny Fadeev <evgeny.fadeev@gmail.com>
Date: Thu, 21 Oct 2010 17:38:46 -0400
Subject: started working on postgres search

---
 .../commands/setup_postgresql_full_text_search.plsql       | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 askbot/management/commands/setup_postgresql_full_text_search.plsql

diff --git a/askbot/management/commands/setup_postgresql_full_text_search.plsql b/askbot/management/commands/setup_postgresql_full_text_search.plsql
new file mode 100644
index 00000000..05d9bc37
--- /dev/null
+++ b/askbot/management/commands/setup_postgresql_full_text_search.plsql
@@ -0,0 +1,14 @@
+CREATE OR REPLACE FUNCTION column_exists(colname text, tablename text)
+RETURNS boolean AS
+$$
+DECLARE
+    q text;
+    onerow record;
+BEGIN
+q = `SELECT attname FROM pg_attribute WHERE attrelid = ( SELECT oid FROM pg_class WHERE relname = '''||tablename||''') AND attname = '''||colname||''' `;
+
+END
+$$
+LANGUAGE plpgsql
+
+CREATE OR REPLACE FUNCTION
-- 
cgit v1.2.3-1-g7c22