diff options
| author | Evgeny Fadeev <evgeny.fadeev@gmail.com> | 2010-10-21 17:38:46 -0400 |
|---|---|---|
| committer | Evgeny Fadeev <evgeny.fadeev@gmail.com> | 2010-10-21 17:38:46 -0400 |
| commit | b4d3656d5050a4875f8b264b7eb3e174cd8faf2b (patch) | |
| tree | 1442225ed1619a576e4bdbdf6720b4e8e160502f | |
| parent | 79a445dea600402535eb801034465f4d42356a0e (diff) | |
| download | askbot-b4d3656d5050a4875f8b264b7eb3e174cd8faf2b.tar.gz askbot-b4d3656d5050a4875f8b264b7eb3e174cd8faf2b.tar.bz2 askbot-b4d3656d5050a4875f8b264b7eb3e174cd8faf2b.zip | |
started working on postgres search
| -rw-r--r-- | askbot/management/commands/setup_postgresql_full_text_search.plsql | 14 |
1 files changed, 14 insertions, 0 deletions
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 |